|
Problem IT34765
|
Status: Closed |
JCC returns UNKNOWN SQL TYPE (-100008) for SYS_REFCURSOR Output parameter for stored procedure
|
| product: |
DB2 CONNECT / DB2CONNCT / B50 - DB2 |
| Problem description: |
When JDBC driver returns REF_CURSOR(2012) data type instead of
CURSOR(-100008) data type using JCC driver version 4.27.25 or
later. Fix the behavior same as observed in old JDBC driver.
w.r.t this type.
e.g: When SP has SYS_REFCURSOR parameter, following can be seen
in jcc traces:
[CallableStatement@873ee217]registerOutParameter (1, -100008)
called
[...] 0000009f logwriter 3 [jcc] BEGIN TRACE_DIAGNOSTICS
[...] 0000009f logwriter 3 [jcc][...][SQLException@76ac0500]
java.sql.SQLException
[...] 0000009f logwriter 3 [jcc][...][SQLException@76ac0500] SQL
state = null
[...] 0000009f logwriter 3 [jcc][...][SQLException@76ac0500]
Error code = -4228
[...] 0000009f logwriter 3 [jcc][...][SQLException@76ac0500]
Message = [jcc][10271][10296][4.27.25] Unrecognized JDBC type:
-100008. ERRORCODE=-4228, SQLSTATE=null
[... 0000009f logwriter 3 at
com.ibm.db2.jcc.am.b7.a(b7.java:794)
[...] 0000009f logwriter 3 at
com.ibm.db2.jcc.am.b7.a(b7.java:66)
[...] 0000009f logwriter 3 at
com.ibm.db2.jcc.am.b7.a(b7.java:116)
[...] 0000009f logwriter 3 at
com.ibm.db2.jcc.am.ao.m(ao.java:1509)
[...] 0000009f logwriter 3 at
com.ibm.db2.jcc.am.CallableStatement.b(CallableStatement.java:41
6)
[...] 0000009f logwriter 3 at
com.ibm.db2.jcc.am.CallableStatement.n(CallableStatement.java:30
0) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Db2 JCC Driver users *
****************************************************************
* PROBLEM DESCRIPTION: *
* When JDBC driver returns REF_CURSOR(2012) data type instead *
* of CURSOR(-100008) data type using JCC driver version *
* 4.27.25 or later. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2V11.5.6.0 *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Db2 JCC Driver users *
****************************************************************
* PROBLEM DESCRIPTION: *
* When JDBC driver returns REF_CURSOR(2012) data type instead *
* of CURSOR(-100008) data type using JCC driver version *
* 4.27.25 or later. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2V11.5.6.0 *
**************************************************************** |
| Comment |
The issue will be fixed in Db2V11.5.6.0 and respective jcc
driver version 4.29.xx. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.11.2020
23.06.2021
23.06.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
