IT13108: A CURSOR WITH HOLD IS CLOSED IF THE FIRST TRANSACTION IS ROLLED BACK

APAR status

• Closed as fixed if next.

Error 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.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all JDBC users up to 4.10.JC6                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Please upgrade to 4.10.JC7                                   *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R350 PSN

     UP

• R350 PSY

     UP

• R370 PSN

     UP

• R370 PSY

     UP

• R410 PSN

     UP

• R410 PSY

     UP