Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
When using a store procedure with in and out parameters, if parameter is set BEFORE registering parameter as an output parameter, it will be sent as NULL to server.
example :
cstmt = connection.prepareCall(sql);
|
cstmt.setLong(1, 42L); |
cstmt.registerOutParameter(1, Types.NUMERIC); |
cstmt.executeQuery();
|
as a workaround, registering parameter before setting value has correct behavior:
cstmt = connection.prepareCall(sql);
|
cstmt.registerOutParameter(1, Types.NUMERIC); |
cstmt.setLong(1, 42L); |
cstmt.executeQuery();
|
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 3.0.9 [ 28449 ] |
| Summary | stored procedure registered output parameter has null if set before registerOutParameter | stored procedure registered output parameter as null if set before registerOutParameter |
| Summary | stored procedure registered output parameter as null if set before registerOutParameter | stored procedure register output parameter as null if set before registerOutParameter command |
| issue.field.resolutiondate | 2022-09-19 13:17:03.0 | 2022-09-19 13:17:03.101 |
| Component/s | stored procedure [ 18800 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Fix Version/s | 3.1.0 [ 28435 ] |