CODEWITHSUNDEEP
oracle-databasejdbcjmeter
Mahmoud
Mahmoud

Reputation: 11

Jmeter JDBC Request returns "Invalid operation for forward only resultset : last" when use "Count Records" on OUT REF CURSOR

I'm new to JMeter and Java, and I need to load test stored procedure that returns Oracle Ref Cursor.

I use JMeter ver 3.1, Here is a JDBC request, with the callable statement to call the procedure as following:

begin test_pkg.test_proc_1('abc',?); end;

Parameter Values : ResultSet
Types: OUT -10
variable names: crsr
Handle ResultSet: Count Records

The test plan runs successfully, but I got the following response error in View Results tree:

Response message: 

java.sql.SQLException: Invalid operation for forward only resultset : last

Upvotes: 0

Views: 566

Answers (1)

Douglas Surber
Douglas Surber

Reputation: 696

According to the JavaDoc you cannot call last() on a FORWARD_ONLY ResultSet and a ref cursor result set is FORWARD_ONLY.

Upvotes: 0

Related Questions