[jboss-jira] [JBoss JIRA] Created: (JBCOMMON-53) ConnectionPool really slow when releasing closed connections (ConnectionError)

[Stephane Poulin (JIRA)]

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