Hi,
Can I use the same opened session for update from 1 table and again for querying from another table.I am doing the following and getting 'Connection is busy with another hstmt'

dbSession = session.beginTransaction();
Cat Pricess = new Cat();
princess.setName("Princess");
princess.setSex('F');
dbSession.save(princess);
dbSession.connection(commit);
dbSession.close();

dbSession = session.beginTransaction();
//Logic for querying from some table
dbSession.close();



Any Help greatly appreciated

Thanks in advance.
Srinivas

If there is an exception thrown or you rollback the transaction the session can NOT be reused. Use a session per-transaction approach will save you from potential grief.

I need more explanation regarding the following statement:

=================
If the Session throws an exception (including any SQLException), you should immediately rollback the transaction, call Session.close() and discard the Session instance. Certain methods of Session will not leave the session in a consistent state.
=================

What those exceptions are? Absolutely any?

Hi,

I guess what that means is within your business logic when some operation on a Hibernate Session fail (ie. throws an exception), you should at least close the session, and if you want to do postmortem operation then open another session within the same transaction, so as to keep with the one session per transaction rule.

Clarence