Hibernate 2

Basically, what I'm trying to do is something like this (this is just an example, please don't read into it beyond the connection issues):



Now I'm here with a Connection object and a Session. If I close the connection with connection.close(), Hibernate will bonk on session.close() or if I try to load/update any more Hibernate objects. If I DON'T close the connection manually, it remains open after I call session.close() and hangs the app...

Does anyone know a way around this? I'd like to be able to check for an open connection and make closing decisions. the session.connection object is null throughout the Session's life unless (and until) session.connection() is called...Then that connection doesn't seem to close after the session is closed...

Also, session.isConnected() returns false even after connection.close() is called.

Don't close the connection. Close any statements/result sets you get, then just forget the connection. Hibernate (or your configured connection manager) looks after that for you.

Note that you cannot guarantee that the connection will remain open after you've closed the session. Perhaps your app is closing because you're continuing to use a result set after you've closed your session? That'll just hang until your request timeout expires.

Great, thank you. There was debate over whether or not session.close() handled connections...My personal debugging showed the connection's boolean "isOpen" value to be true after session.close() was called and the javadocs are a bit ambiguous on the subject.