commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi Rajamiyer <ravirajami...@yahoo.com>
Subject DBCP - Connection Closed problem
Date Mon, 12 Mar 2007 20:27:59 GMT
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 
 
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message