IC83767: FINALIZATION OF BLOB OBJECTS STARTS A NEW TRANSACTION IF AUTOCOMMIT IS SET TO FALSE

APAR status

• Closed as program error.

Error description

• If your Informix JDBC based application deals with blob objects,
  once it finished using them forgetting all references,  the blob
  objects become eligible to be garbage collected. Because the
  finalizer code for blobs perform database operations, if
  autocommit=false for the connection,  a new local transaction is
  started.
  
  This interferes with the normal working of the applications and
  in particular may prevent XA transactions to be started.
  

Local fix

• A possible workaround can be to set autocommit=true, if the
  application logic allows it
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of IBM Informix JDBC from 3.10.JC1 to 3.70.JC4         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Update to JDBC-3.70.JC6                                      *
  ****************************************************************
  

Problem conclusion

• Problem Fixed In JDBC-3.70.JC6
  

Temporary fix

Comments

• http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
  http://www.ibm.com/support/fixcentral
  

APAR Information

• 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

• R370 PSN

     UP