You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Ravi Rajamiyer <ra...@yahoo.com> on 2007/03/12 21:27:59 UTC

DBCP - Connection Closed problem

I have just started using  commons-DBCP for connection pool management. I am getting the following stach trace in one of my applications. This happens in a loop with the following sequence.
 
 start-loop
   get connection
   do DB operation
   close connecion
 end loop
 
 Any idea what would be the probelm? Thanks.
 
 -----------------------------------------------------------------
 
 java.sql.SQLException: Closed Connection
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
         at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:1038)
         at org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.setAutoCommit(ConnectionImpl.java:325)
         at org.apache.commons.dbcp.datasources.PerUserPoolDataSource.setupDefaults(PerUserPoolDataSource.java:415)
         at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:654)
         at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:615)
         at com.yahoo.sm.am.utils.db.PooledDBCPConnection.openConnection(PooledDBCPConnection.java:51)
         at com.yahoo.sm.am.utils.db.ConnectionManager.getConnection(ConnectionManager.java:94)
         at