[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2447) Connection leak if logAndClearWarnings throws

[Jeppe N. Madsen (JIRA)]

Connection leak if logAndClearWarnings throws 
----------------------------------------------

         Key: HHH-2447
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2447
     Project: Hibernate3
        Type: Bug

  Components: core  
    Versions: 3.1.3, 3.2.2    
 Environment: Database product name : DB2/NT
Database product version : SQL08025
JDBC driver name  : IBM DB2 JDBC Universal Driver Architecture
Hibernate 3.1.3 (seems to exist in 3.2.2 as well)
JDBC driver version  : 2.9.31
    Reporter: Jeppe N. Madsen
    Priority: Minor


In ConnectionManager.closeConnection, logAndClearWarnings is called before connection.close() is called. If this call throws an exception, the connection is never closed. 

We have observed that DB2 sometimes throws an Error because the SQLWarning chain is wrong:

[14-02-07 11:36:30:889 CET] 10b0b533 WebGroup      E SRVE0026E: [Servlet Error]-[SQLWarning chain holds value that is not a SQLWarning]: java.lang.Error: SQLWarning chain holds value that is not a SQLWarning
	at java.sql.SQLWarning.getNextWarning(SQLWarning.java:109)
	at org.hibernate.util.JDBCExceptionReporter.logWarnings(JDBCExceptionReporter.java:50)
	at org.hibernate.util.JDBCExceptionReporter.logWarnings(JDBCExceptionReporter.java:33)
	at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings(JDBCExceptionReporter.java:22)
	at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:443)
	at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:379)
	at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:318)
	at org.hibernate.impl.SessionImpl.close(SessionImpl.java:293)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira