ConnectionPool really slow when releasing closed connections (ConnectionError) ------------------------------------------------------------------------------ Key: JBCOMMON-53 URL: http://jira.jboss.com/jira/browse/JBCOMMON-53 Project: JBoss Common Issue Type: Bug Security Level: Public (Everyone can see) Components: common-core Environment: Windows XP and Linux; JBoss 4.0.0 or JBoss 4.2.2 with Oracle 10g Reporter: Stephane Poulin Assigned To: Dimitris Andreadis When databases are restarted after a shut down or a crash, JBoss connection pool's takes about 10 minutes to release all closed connections and get fresh ones. Even after the db restard I get: 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.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:399) at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:722) at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:202) or 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.rollback(PhysicalConnection.java:1142) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcRollback(BaseWrapperManagedConnection.java:515) at org.jboss.resource.adapter.jdbc.WrappedConnection.rollback(WrappedConnection.java:460) Apparently the pool purges itself but takes 10 minutes to do so. There must be a way to get connections as soon as the db server is back. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira