Support Article
AutoCommit Error displays while retrieving data from database
SA-59353
Summary
The AutoCommit Error displays sporadically while retrieving data from an external database.
Error Messages
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WSJdbcWrapper.java:122)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.activate(WSJdbcConnection.java:2900)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.getAutoCommit(WSJdbcConnection.java:2016)
at com.pega.pegarules.data.internal.access.DatabaseConnectionImpl.getAutoCommit(DatabaseConnectionImpl.java:806)
at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.returnConnection(ConnectionManagerImpl.java:2221)
Steps to Reproduce
Unknown
Root Cause
A defect or configuration issue in the operating environment.
The error displays because the database connection returned from the pool by the application server is out-of-date.
Resolution
Make the following change to the operating environment:
Validate new and existing connections by adding validation to the database connection pool for each data source.
Published October 13, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.