I want to use hibernate.connection.release_mode in the case of non-JTA connections and I am trying to understand what Hibernate does when release_mode is set to "after_transaction".

The documentation says "For a non-JTA connection, it often makes sense to release the connection at the end of each transaction, by using after_transaction."

Can someone explains how Hibernate figures out that the transaction is completed ? Especially in the case of a query that does not invoke a commit(), how does Hibernate know that it's safe to close the session ?
(I do not use the Transaction object so a query for me looks like this :
List objects = session.createQuery(oqlQuery).list();)

If this is explained in the 3.1 documentation, can someone point me to it, I've only been able to find documentation for 3.0.5.

Thanks.

Laurent

When you close the session, its db connection is also closed.

I think that what you said applies if you set hibernate.connection.release_mode = "on_close" which is the default value in 3.0.5. The documentation says : "By default, a JDBC connection is held until the session is explicitly closed or disconnected."
That's not what I want. I want to understand what the option after_transaction does.

I guess then you'll have to close the transaction.

You can invoke commit (or rollback, it shouldn't make a difference) after a query to complete the transaction.
Otherwise, it's going to be kept open.