Hello

i'm using Nhibernate and i have one problem:
When i do a rollback after an exception, it works but i can't execute queries anymore.
I have the exception "begin failed with sql exception" when i want to begin a new transaction !

Any idea ? [/code]

The full exception might help. Also, are you discarding your Session and starting from scratch? This is important, because after an exception, a given Session is considered to be at least potentially corrupted. What happens if you begin a new transaction on a new Session?

rigth, it works if i do a session = factory.OpenSession(); when catching the exception....

thanks !