APAR status
Closed as program error.
Error description
When fetching metadata from the database server within a loop, a Java application will encounter the following exception: java.sql.SQLException: The cursor has been previously released and is unavailable. at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:445) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:417) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:385) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3138) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3419) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2326) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2251) at com.informix.jdbc.IfxSqli.executeFetch(IfxSqli.java:2002) at com.informix.jdbc.IfxSqli.getaRow(IfxSqli.java:4028) at com.informix.jdbc.IfxResultSet.next(IfxResultSet.java:389) at com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabas eMetaData.java:5389) at JavaTest.test(JavaTest.java:60) at JavaTest.main(JavaTest.java:36) Caused by: java.sql.SQLException at com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:445) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:417) at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:385) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3424) ... 8 more
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of JDBC 4.10.JC12. * **************************************************************** * PROBLEM DESCRIPTION: * * When fetching metadata from the database server within a * * loop, a * * Java application will encounter the following exception: * * * * java.sql.SQLException: The cursor has been previously * * released * * and is unavailable. * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fixed in JDBC 4.10.JC13.
Temporary fix
Comments
APAR Information
APAR number
IT26333
Reported component name
IBM JDBC
Reported component ID
5724I3501
Reported release
410
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-18
Closed date
2019-09-19
Last modified date
2019-09-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IBM JDBC
Fixed component ID
5724I3501
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVRDQ","label":"Informix JDBC"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"410","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
19 September 2019