[hibernate-issues] [Hibernate-JIRA] Created: (HBX-1145) Warning message "The transaction remains active, [..]" at the end of the hbm2java ant task

Warning message "The transaction remains active, [..]" at the end of the hbm2java ant task ------------------------------------------------------------------------------------------ Key: HBX-1145 URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-1145 Project: Hibernate Tools Issue Type: Bug Components: ant, hbm2java Affects Versions: 3.2.2 Environment: Hibernate Tools 3.2.2.GA, DB2, Seam 2.1.2.GA/seam-gen, http://anonsvn.jboss.org/repos/hibernate/branches/Branch_3_2/HibernateExt..., http://anonsvn.jboss.org/repos/hibernate/core/trunk/core/src/main/java/or... Reporter: Julien Kronegg Priority: Minor When doing a hbm2java ant task to generate entities from the database, an exception occurs when closing the connection pool if transactions are used. INFO: cleaning up connection pool: jdbc:db2://192.168.17.12:8801/TES1 org.hibernate.connection.DriverManagerConnectionProvider close WARNING: problem closing pooled connection Throwable occured: com.ibm.db2.jcc.b.SqlException: ... java.sql.Connextion.close() requested while a transaction is in progress on the connection. The transaction remains active, and the connection cannot be closed. ERRORCODE=-4471, SQLSTATE=null ... // obfuscated calls from com.ibm.db2.jcc.b.* at org.ibm.db2.jcc.b.jb.close(jb.java:1089) at org.hibernate.connection.DriverManagerConnectionProvider.close(DriverManagerConnectionProvider:175) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder:95) ... at org.hibernate.tool.ant.Hbm2JavaExporterTask.configureExporter(Hbm2JavaExporterTask:43) This is only a warning and the hbm2java ant task do the Java file generation correctly. However, this warning make think about a problem when generating the entities from the database. The solution may be to commit/rollback the transaction (if any) before closing the connection pool. This could be done in JDBCBinder.readFromDatabase() or in the DriverManagerConnectionProvider.close() methods. Workaround: ----------------- Set the following property in the hibernate properties file used for the ant task: hibernate.connection.autocommit=true -- 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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira