[jboss-jira] [JBoss JIRA] Created: (JBAS-5526) DB Connections established which fail check-valid-connection-sql do not immediatly close their connection

DB Connections established which fail check-valid-connection-sql do not immediatly close their connection --------------------------------------------------------------------------------------------------------- Key: JBAS-5526 URL: http://jira.jboss.com/jira/browse/JBAS-5526 Project: JBoss Application Server Issue Type: Bug Security Level: Public (Everyone can see) Affects Versions: JBossAS-4.2.2.GA Environment: Red Hat Enterprise 5.1, MS SQL Server 2005 Reporter: Dan Killey When a DB connection is attempted to be created where it is configured with check-valid-connection-sql, if the socket/connection succeeds but the check-valid-connection-sql statement fails a connection remains open until GC. In a large volume environment this can lead to many sockets being opened until GC occurs and can thus run into file handle limits. If a valid TCP connection was established, but the SQL fails, I am suggesting the connection should also be closed at the time of failure, not waiting till GC. -- 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