Hibernate version:3.1

Am using session-per-conversation pattern using Servlet filters. Am currently using some hibernate previous releases disconnect and reconnect functions. Since these functions are deprecated in 3.1 they have no effect. I read that in 3.1 connections will be disconnected automatically after commit. But when am calling session.isConnected() after session.commit, still it returns true only. Am new to hibernate. Please help with a way to disconnect
a connection from the session.

I used the following code for testing disconnection in Hibernate 3.1

session=HibernateUtil.getSessionFactory().openSession();
Transaction t = session.beginTransaction();
-----------------
-----------------
t.commit();
System.out.println(session.isConnected());


and


session=HibernateUtil.getSessionFactory().openSession();
Transaction t = session.beginTransaction();
-----------------
-----------------
t.commit();
session.disconnect();
System.out.println(session.isConnected());



Both of them returns true only.. Sorry if my doubt is silly..
Thanks in advance.

I think you are getting Session and Transaction confused.

The transaction is a wrapper around the commands you are giving to the database.

http://www.hibernate.org/hib_docs/v3/ap ... ction.html

And a session
http://www.hibernate.org/hib_docs/v3/ap ... ssion.html

committing a transaction does not close a database connection, it just forces all your changes to be persisted.

session.close() will close your database connection. I believe this is the best practice as I haven't seen a newer example that uses session.disconnect. This is just my opinion though maybe this will help.

http://forum.hibernate.org/viewtopic.php?t=924565

Most of the newer examples only show session.close()
http://www.hibernate.org/42.html

Hope this helps.

Thanks ethnarch for ur rply.

I want to use session-per-conversation pattern in my application( i.e., Same session should be reused for more than one HTTP requests and for each request JDBC connection will be established and at the end of the request, the connection will be disconnected). For that, I need to disconnect a JDBC connection during user think time and reconnect whenever needed with a single hibernate session. It is possible in older versions(3.0-am checked) of hibernate using disconnect and reconnect methods. But am not able to do that in hibernate 3.2.5ga. Please guide me in doing this.

Session-per-Conversation pattern detail : http://www.hibernate.org/42.html

Thanks ethnarch for ur rply.

I want to use session-per-conversation pattern in my application( i.e., Same session should be reused for more than one HTTP requests and for each request JDBC connection will be established and at the end of the request, the connection will be disconnected). For that, I need to disconnect a JDBC connection during user think time and reconnect whenever needed with a single hibernate session. It is possible in older versions(3.0-am checked) of hibernate using disconnect and reconnect methods. But am not able to do that in hibernate 3.2.5ga. Please guide me in doing this.

Session-per-Conversation pattern detail : http://www.hibernate.org/42.html