https://bz.apache.org/bugzilla/show_bug.cgi?id=66027
Bug ID: 66027
Summary: JDBC calling stored procedure with OUT params get
mixed up
Product: JMeter
Version: 5.4.3
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: Main
Assignee: issues@jmeter.apache.org
Reporter: mark.lehky+jme...@gmail.com
Target Milestone: JMETER_5.5
I am using JMeter JDBC Request to call a stored procedure with OUT parameters.
My JDBC Request is defined as follows:
Query Type: Callable Statement
Query: CALL XXX_schema.YYY_stored_proc(?,?,?,?)
Parameter Values: "{}",null,null,null
Parameter Types: IN CLOB,OUT CHAR,OUT CHAR,OUT VARCHAR
Variable Names:JSON_CLOB,Status,Error_Code,Error_Message
Result variable name: result
Handle ResultSet: Store As Object
In this configuration I am expecting the stored procedure to reply with an
error!
Looking in View Results Tree at my step, I see the the following in Response
Body:
Output variables by position:
[2] PRECHKFAIL
[3] E
[4] Division Not Valid. Pre-Check failed. Get URs process was not completed.
Looking in Debug Sampler, I see the following Variables:
Error_Code=Division Not Valid. Pre-Check failed. Get URs process was not
completed.
Error_Code_#=0
Error_Message_#=0
JSON_CLOB=PRECHKFAIL
JSON_CLOB_#=0
Status=E
Status_#=0
This does not seem to line up. In position 2, I defined the variable "Status",
so I am expecting to see:
Status=PRECHKFAIL
Status_#=0
Similarly for Error_Code in position 3, and Error_Message in position 4:
Error_Code=E
Error_Code_#=0
Error_Message_#=0
Error_Message=Division Not Valid. Pre-Check failed. Get URs process was not
completed.
Further, my variable "JSON_CLOB" should be unmodified, since this is defined as
an IN param.
Lastly, I am still checking with my developers, but I believe the positions of
variables 2 and 3, in the Response Body are reversed.
--
You are receiving this mail because:
You are the assignee for the bug.
