Hello,

I use NH to access an oracle database. Sometimes I get an oracle exception when inserting a row due to a constraint violation. I use a transaction and rollback it in case of an exception.
The problem is that from that moment my last insert remains in the session insertion list and I cant execute any other query without having the same exception. If I call session.clear() it works again but I lose all my entities in the session.
Is there any efficient way to clear the session state after an exception ?

thank you
Anthony

No. It is an hibernate requirement: when an HibernateException is thrown, you must discard or reset your session. There is no alternative.

I may though give you an advice... In my opinion although the scenario is not common it is though expected... You can evict the objects that caused the exception from the session using session.Evict or even session.Clear to clear-out the session.

Of course that this is not a good idea for any kind of exception, you should apply this only in the case of an ADO exception and if the items being saved are not many (in complex situations I'm not sure of what entity caused the exception and what to evict).