Unclosed connection when using SessionFactoryUtils

[parwen]

Using:
Hibernate 2.1.8, JBoss 4.0.2 and Spring 1.2.4

I have a SLSB that has transaction attribute Required. This SLSB makes a call to another SLSB that has transaction attribute NotSupported. I use SessionFactoryUtils to grab a Hibernate Session inside the second SLSB. A session is opened and used for reading only, but on exit from the method JBoss logs that it has closed a connection:

2005-09-20 09:22:33,589 INFO [http-0.0.0.0-8080-2][org.jboss.resource.connectionmanager.CachedConnect ionManager] Closing a connection for you. Please close them yourself: org.jboss.resource.adapter.jdbc.WrappedConnection@ e0286d
java.lang.Exception: STACKTRACE

Later on in the log I get

2005-09-20 09:22:35,574 WARN [Finalizer][net.sf.hibernate.impl.SessionImpl] finalizing unclosed session with closed connection

It does not seem like the session gets properly closed. BTW don´t use any Spring transaction manager. Is this a bug or is it a configuration issue?

[parwen]

Guess I have to use HibernateTemplate or HibernateInterceptor to get that session closed properly... Am I right? :oops:

[Andreas Senft]

Indeed