On 05/01/2008, Abram Catalano <[EMAIL PROTECTED]> wrote:
> So, digging into the JDBCSampler.java class, I see:
>
> Data data = getDataFromResultSet(rs);
> res.setResponseData(data.toString().getBytes());
>
> Is there any way to get the "data" object into the "res" (SampleResult)
> object, so I can at least have beanshell access to the columns of the
> result set?
Only by amending the JDBC sampler code.
Normally toString() produces sensible output. I don't recall ever
seeing output such as you describe, but then I've only used Derby and
MySql. Not sure if the test databases I used had date columns.
Maybe there is a problem with the Oracle JDBC driver?
Might be worth checking if the same behaviour occurs with other
databases and timestamps.
>
> Full example below:
>
> public SampleResult sample(Entry e) {
> ......
>
> if (SELECT.equals(_queryType)) {
> stmt = conn.createStatement();
> ResultSet rs = null;
> try {
> rs = stmt.executeQuery(getQuery());
> Data data = getDataFromResultSet(rs);
> res.setResponseData(data.toString().getBytes());
> } finally {
> close(rs);
> }
> }
> ....
> }
>
> How has noone else needed this?
>
> Thanks in advance,
> -Abram
>
>
> Abram Catalano wrote:
> > Apologies in advance if this is obvious. I crawled google and the
> > archives and didn't see what I needed.
> >
> > I have a JDBC sampler set up, and I want to make some assertions on
> > the rows' data returned. I see that I can dump the JDBC response to a
> > file, and then subsequently iterate over the file, but that is not
> > getting me far enough.
> >
> > 1) I dont really want to use a file, I just want to iterate over the
> > jdbc reponse in memory. They're small responses (a few rows). how?
> > 2) One issue I am having is that some of the rows contain timestamps.
> > It appears any response data I see is "toString()"ing the data, so
> > timestamps just appear as their Java class/mem address (e.g.
> > "[EMAIL PROTECTED]" )
> >
> > Is there some way to provide a row object (and some mapping code,
> > something like Spring's JdbcTemplate provides), and be able to iterate
> > over a list of row objects? I need to do things like see if a
> > timestamp is within +- 5 seconds of what it should be.
> >
> > I haven't looked at BeanShell much yet. I'd prefer some simple Java
> > code that validates/tests JDBC response data. (e.g. boolean
> > verify(List<Row> response) )
> >
> > Also, if there is an easy extension point for JDBC response processing
> > (that takes a ResultSet as an argument), I'd be interested in writing
> > up some code to help out in this area.
> >
> > Thanks in advance.
> > -Abram
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
