[Bug 66027] New: JDBC calling stored procedure with OUT params get mixed up

[bu...@apache.org]

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+jmeter@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.