Can anyone tell me where I can find the setting to enable / disable session close on TX commit. I'm using JTA, jboss and hibernate 3.2.

Startup Logs:


Hibernate version:
3.2

Mapping documents: N/A

Code between sessionFactory.openSession() and session.close(): N/A
session.close() throws exception

Full stack trace of any exception that occurs:


Name and version of the database you are using: N/A


The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

See http://www.hibernate.org/hib_docs/v3/ap ... SE_SESSION

Don't forget to vote !

Im using a hibernate service to create my session factory. No matter where i put this setting it doesnt take effect.

Ive put it in hibernate.properties and my hbm.xml. and its always set to enabled.

How do i change it to false.. and why is it set to true.. seems like a silly assumption, since most db providers tell you to close your session with the db in every finally block.

Hi jimithang3,

if you are using auto close =true then you need not to close session explicitly .Even if you are using Spring the You could use AOP for automated Transactional handling.

I resolved the issue, it turned out to be kinda tricky, at least to me so heres the fix incase anyone else had the same problems.

I deployed my data access code as a hibernate HAR file. The har mbean descriptor doesn't have a setting to toggle the AUTO_SESSION_CLOSE.
So naturally I didn't have a session.close() in my finally blocks. Under heavy load the transactions started committing 2x and the system would become unstable until JTA expired the failed transactions.

To fix I deployed data access code as a SAR file with a HibernateService descriptor which provides access to the AUTO_SESSION_CLOSE, which is now disabled and im closing every connection manually in the finally blocks.