Troubleshooting
Problem
Closed Connection errors seen in the system.log.
Symptom
[2013-08-19 10:03:11.433] ERROR 000310100007 UTIL.FRAME_JDBC.ERR_ConnectionFactory [ConnectionFactory] Could not close the connection.
[2013-08-19 10:03:11.433] ERROR [1376899391433] Closed Connection
[2013-08-19 10:03:11.433] ERRORDTL [1376899391433]java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:5389)
at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:1578)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:1563)
at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:94)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:80)
at com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionFactory.verify(ConnectionFactory.java:259)
at com.sterlingcommerce.woodstock.util.frame.pool.Pool.verify(Pool.java:976)
at com.sterlingcommerce.woodstock.util.frame.pool.PoolManager.getItem(PoolManager.java:175)
at com.sterlingcommerce.woodstock.util.frame.pool.PoolManager.getItem(PoolManager.java:156)
at com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.testOnReserve(ConnectionService.java:646)
at com.sterlingcommerce.woodstock.util.frame.jdbc.AbstractVendor.getNonTransactionalConnection(AbstractVendor.java:137)
at com.sterlingcommerce.woodstock.util.frame.jdbc.AbstractVendor.getConnection(AbstractVendor.java:55)
at com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.getConnection(ConnectionService.java:226)
at com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionService.getConnection(ConnectionService.java:769)
at com.sterlingcommerce.woodstock.util.frame.jdbc.JDBCService.getConnection(JDBCService.java:256)
at com.sterlingcommerce.woodstock.dmi.visibility.db.DBConnectionManager.getConnection(DBConnectionManager.java:46)
at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.getConnection(DatabaseOperation.java:439)
at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation._runInTransaction(DatabaseOperation.java:321)
at com.sterlingcommerce.woodstock.mailbox.db.DatabaseOperation.runInTransaction(DatabaseOperation.java:144)
at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouseQueue.executeStatementsAsExecutor(DmiVisEventWarehouseQueue.java:345)
at com.sterlingcommerce.woodstock.dmi.visibility.db.DmiVisEventWarehouseQueue.run(DmiVisEventWarehouseQueue.java:319)
at java.lang.Thread.run(Thread.java:736)
[2013-08-19 11:07:39.402] ERROR 000310100007 UTIL.FRAME_JDBC
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21650312