Hi all,

The manual says:
auto (the default): this choice delegates to the release mode returned by the org.hibernate.transaction.TransactionFactory.getDefaultReleaseMode() method. For JTATransactionFactory, this returns ConnectionReleaseMode.AFTER_STATEMENT; for JDBCTransactionFactory, this returns ConnectionReleaseMode.AFTER_TRANSACTION.

http://docs.jboss.org/hibernate/orm/4.3/manual/en-US/html_single/#transactions-connection-release

According to manual, when I set

The actually release mode should be AFTER_TRANSACTION.


But in fact, when I run the application with above configuration, it's behavior does not equal to the same application with following setting


Anything I missed?



My setup information:
hibernate 4.3.8 +
java 8/spring 4.1.4/hikariCP 2.3.2

We are currently upgrading from Hibernate 3 to 5 and noticed the same behavior: Hibernate defaults the connection release mode to "on_close" when the factory class is JDBCTransactionFactory:

https://github.com/hibernate/hibernate-orm/blob/5.0/hibernate-core/src/main/java/org/hibernate/resource/transaction/backend/jdbc/internal/JdbcResourceLocalTransactionCoordinatorBuilderImpl.java

Setting AFTER_TRANSACTION solved the issue for us but we're still testing:


I couldn't find a section on Connection Release Modes in the Hibernate 5 ORM User Guide so I'm not sure if this is a bug or if we're doing something wrong. The JavaDoc for ConnectionReleaseMode says "on_close" is legacy (Hibernate2 and pre-3.1) behavior.

We are using Hibernate 5.0.1.FINAL.