DB2 - Problem description
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) |