Hi,

I was wondering whether session.getTransaction().rollback(); automatically closes the session in hibernate 3.3.1 GA?

I'm trying to close the session after the rollback in a finally block, as is recommended by the documentation, but I get an exception saying that the session is already closed. If I comment out the session.close() statement, the code runs fine, as shown below:


session.beginTransaction();
try
{
session.save(account);
session.getTransaction().commit();
session.close();

return ApplicationResponseEnum.ACCOUNT_CREATED;
}
catch (RuntimeException e)
{
session.getTransaction().rollback();
finally
{
//session.close();
}

TIA,
- Ole

There is a configuration option for this: hibernate.transaction.auto_close_session

See table 3.7 on this page: http://www.hibernate.org/hib_docs/v3/re ... ional.html

Hi,

Thanks for pointing that out. I'm running with Teneo, so I thought maybe Teneo set it. I tried adding hibernate.transaction.auto_close_session=true to my hibernate.properties, and now I'm getting more session is already closed exceptions from other areas of my code, so that rules out the configuration option.

Any other ideas?

Thanks again,
- Ole

Just in case a little more context is helpful. The test I'm running tries to insert a duplicate account, which triggeres a org.hibernate.exception.ConstraintViolationException. It also causes this to be logged:

2008-11-13 10:22:44,463 [main] ERROR org.hibernate.event.def.AbstractFlushingEventListener - Could not synchronize database state with session

Maybe hibernate automatically closes the session, if it can't synchronize it?

Thanks again,
- Ole

The hibernate.transaction.auto_close_session should be set to false. Which seems to be the default since your problems got worse when setting it to true. But... take a look at your code again...



If the transaction is committed successfully the next line calls session.close(), which is also called a second time in the 'finally' part.

:-) Whoops - Thanks! I need to stop burning the midnight oil.

Thanks again,
- Ole