PH67656: ROLLBACK() SHOULD NOT BE CALLED WHILE IN AUTO-COMMIT MODE. J2CA0081E: METHOD DESTROY FAILED WHILE TRYING TO EXECUTE METHOD

APAR status

• Closed as program error.

Error description

• [6/23/25 22:17:32:567 PDT] 00000c37 MCWrapper     E   J2CA0081E:
  Method destroy failed while trying to execute method destroy on
  ManagedConnection WSRdbManagedConnectionImpl@e34f8e61 from
  resource No longer available. Caught exception:
  com.ibm.ws.exception.WsException: DSRA0080E: An exception was
  received by the Data Store Adapter. See original exception
  message: rollback() should not be called while in auto-commit
  mode.. with SQL State : 25000 SQL Code : 0
  	at net.sourceforge.jtds.jdbc.JtdsConnection.rollback(JtdsConne
  ction.java:2168)
  	at net.sourceforge.jtds.jdbcx.proxy.ConnectionProxy.rollback(C
  onnectionProxy.java:518)
  	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.cleanup
  Transactions(WSRdbManagedConnectionImpl.java:4914)
  	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.destroy
  (WSRdbManagedConnectionImpl.java:3993)
  	at com.ibm.ejs.j2c.MCWrapper.destroy(MCWrapper.java:2201)
  	at com.ibm.ejs.j2c.FreePool.returnToFreePool(FreePool.java:604)
  
  	at com.ibm.ejs.j2c.PoolManager.release(PoolManager.java:2987)
  	at com.ibm.ejs.j2c.MCWrapper.releaseToPoolManager(MCWrapper.ja
  va:2728)
  	at com.ibm.ejs.j2c.ConnectionEventListener.connectionClosed(Co
  nnectionEventListener.java:399)
  	at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.process
  ConnectionClosedEvent(WSRdbManagedConnectionImpl.java:2084)
  	at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.closeWrapper(WSJ
  dbcConnection.java:1095)
  	at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.j
  ava:262)
  	at com.ibm.ws.rsadapter.jdbc.WSJdbcObject.close(WSJdbcObject.j
  ava:206)
  	at com.tririga.dataaccess.ConnectionManager.close(ConnectionMa
  nager.java:625)
  	at com.tririga.platform.persistence.ExposedDbUtils.doInNewConn
  ection(ExposedDbUtils.java:246)
  	at com.tririga.platform.persistence.ExposedDbUtils.access$100(
  ExposedDbUtils.java:67)
  	at com.tririga.platform.persistence.ExposedDbUtils$1.execute(E
  xposedDbUtils.java:171)
  	at com.tririga.platform.persistence.ExposedDbUtils$UnmanagedTh
  read.run(ExposedDbUtils.java:405)
  Caused by: java.sql.SQLException: rollback() should not be
  called while in auto-commit mode. DSRA0010E: SQL State = 25000,
  Error Code = 0
  	... 18 more
  To suppress these warnings, we can deliver an iFix that ignores
  the rollback() should not be called while in auto-commit mode
  exceptions when a connection is being destroyed. Since the
  connection is already having some errors and we are destroying
  it , so suppressing the warning is safe. Open Liberty already
  includes this suppression, which is why you dont see the error
  there. Applying the same fix will prevent these log entries in
  your environment, ensuring consistent behavior between Open
  Liberty and TWAS. We are waiting for the APAR to fix the issue
  in tWAS.
  
  Avoid logging error from JDBC driver when closing connection
  #25141
  
  
  See the Open Liberty issue for details:
  https://github.com/OpenLiberty/open-liberty/issues/25141
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: J2CA0081E is logged when closing a      *
  *                      connection                              *
  *                      during pool maintenance and the         *
  *                      connection raises an error.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  During pool maintenance, harmless errors like J2CA0081E show up
  when unused connections fail to close. They
  donâ??t affect the app but add unnecessary log noise.
  

Problem conclusion

• Downgrading the log severity of J2CA0081E from error to debug,
  thereby reducing log noise.
  
  The fix for this APAR is targeted for inclusion in fix pack
  9.0.5.26 and 8.5.5.29. For more information, see 'Recommended
  Updates for WebSphere Application Server':
  https://www.ibm.com/support/pages/node/715553
  

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

• Fixed component name

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels