Informix - Problem description
Problem IT13108 | Status: Closed |
A CURSOR WITH HOLD IS CLOSED IF THE FIRST TRANSACTION IS ROLLED BACK | |
product: | |
IBM JDBC / 5724I3501 / 410 - Informix 4.10 | |
Problem description: | |
In a Java program that uses the Informix JDBC driver, and with autocommit disabled, you have defined and opened a cursor with hold: conn.setAutoCommit(false); Statement stmt = conn.createStatement( ResultSet.HOLD_CURSORS_OVER_COMMIT); ResultSet resultSet = stmt.executeQuery(mySelectStatement); If in the loop that retrieves the result, the first transaction operation is a ROLLBACK rather than a COMMIT , the cursor gets closed and the following fetch() operation will fail. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all JDBC users up to 4.10.JC6 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to 4.10.JC7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 11.01.2016 28.06.2016 28.06.2016 |
Problem solved at the following versions (IBM BugInfos) | |
4.10.JC7 | |
Problem solved according to the fixlist(s) of the following version(s) |