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
