tracking down an unclosed session

krebsnet · **Joined:** Fri Dec 17, 2004 12:54 pm **Posts:** 13

Hi,
I'm running hibernate in a tomcat container and there seems to be a background thread that is printing a message to console saying...

WARNorg.hibernate.jdbc.ConnectionManager [WARN ] - unclosed connection, forgot t
o call close() on your session?

I make a lot of calls to hibernate and am wondering if there is a way where I can get some more info as to what session is open.

pksiv · **Posted:** Tue Oct 25, 2005 1:17 pm

krebsnet wrote:

Hi,
I'm running hibernate in a tomcat container and there seems to be a background thread that is printing a message to console saying...

WARNorg.hibernate.jdbc.ConnectionManager [WARN ] - unclosed connection, forgot t
o call close() on your session?

I make a lot of calls to hibernate and am wondering if there is a way where I can get some more info as to what session is open.

It's not a background thread. This message is displayed when prior to the ConnectionManager being GC'd in the finalize method.

You need make sure that you are always closing a session prior to returning the response to the User.

kgignatyev · **Posted:** Tue Oct 25, 2005 1:40 pm

The best way to make sure that session/connection get closed is to use some kind of aspectization:
HiveMind based Interceptor from HiveTranse (http://hivetranse.sourceforge.net/ )
Spring based proxy (not HibernateTemplate) http://www.onjava.com/pub/a/onjava/2005 ... tions.html

Or roll your own CGLib based weaver: http://kgionline.com/articles/aop_1/aop1.jsp

christian · **Posted:** Tue Oct 25, 2005 1:41 pm

http://hibernate.org/42.html
http://hibernate.org/43.html