Im running into a random error and have a theory but looking for some help from all of you nhibernate experts!!
Refer to the following generic code: using (var session = NHibernateSessionFactory.Instance.OpenStatelessSession()) using (var txn = session.BeginTransaction()) { var _Model = session .CreateStoredProcQuery("stored_proc") .SetTimeout(120) .UniqueResult<Model>(); txn.Commit(); return _Model; } According to Nhibernate documentation this will automatically rollback a transaction that fails however I am getting an error that says "Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0" The stored proc being called has a sql transaction which I have run in concurrency testing via 10 sessions with 10 executions each and cannot reproduce it at a sql level. I am curious if in the above code, since nhibernate is using a stateless session, and calling a stored proc if a system error occurs if nhibernate is smart enough to rollback the transaction or if that is what is causing the problem... ie nhibernate cannot rollback because it thinks there is a mismatch. The other consideration is in the stored proc if I also include SET XACT_ABORT ON; if this might also be the reason as it is currently set to off. Hoping someone can help!!! Thanks -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/nhusers/e6876f72-92b2-4b01-a27b-896cfd498bb4n%40googlegroups.com.