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?
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]
