https://issues.apache.org/bugzilla/show_bug.cgi?id=57322
Bug ID: 57322
Summary: JDBC: add methods to deal with ResultSets(cursors)
returned by callable statements
Product: JMeter
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P2
Component: Main
Assignee: [email protected]
Reporter: [email protected]
Created attachment 32265
--> https://issues.apache.org/bugzilla/attachment.cgi?id=32265&action=edit
Patch to add ResultSet returned from Callable Statements.
In Oracle it is a common practice to return queries from stored procedures as a
construct called refcursor. Refcursors are then returned as ResultSets to Java
and if you really want to do thorough load test you actually have to loop
through the whole result set. The current code does not iterate through those
ResultSet and stores the ResultSet as string so it is not possible to do any
further processing on it. If the ResultSet is stored as a Object they can
actually be iterated in JSR223 of BeanShell script. It would also be nice if
the JDBC sampler would actually just iterate through the RS by itself.
Attached is a patch for your consideration, that adds the code and
configuration options for dealing with ResultSets : Store as String, Store as
Object, and Count Records.
Regards
Yngvi
--
You are receiving this mail because:
You are the assignee for the bug.
