FYI : I am using NHibernate 2.1.0.4000 On Jan 12, 5:05 pm, Surabhi <[email protected]> wrote: > I have two session factories one uses MS SQL Server 2008 and other > uses IBM DB2 . > > My requirement is as part of a transaction i need to update both the > databases. > > Here is the code i am using > > using (TransactionScope scope = new TransactionScope > (TransactionScopeOption.Required)) > { > Console.WriteLine("Txn ID = " + > System.Transactions.Transaction.Current.GetHashCode()); > ISessionFactory nGMSessionFactory = > (ISessionFactory)ContextRegistry.GetContext().GetObject > ("SessionFactory"); > ISession session = nGMSessionFactory.OpenSession(); > Console.WriteLine("Txn ID= " + session.Transaction.GetHashCode > ()); > Vechile v = session.Get<Vechile>("19UTB18508A900093"); > v.GNRCOMMENTTXT = "Test two phase commit2"; > session.SaveOrUpdate(v); > session.Flush(); > ISessionFactory dB2SessionFactory = > (ISessionFactory)ContextRegistry.GetContext().GetObject > ("DB2SessionFactory"); > ISession dB2Session = dB2SessionFactory.OpenSession(); > Console.WriteLine("Txn ID= " + > dB2Session.Transaction.GetHashCode()); > dB2Session.Update(v); > dB2Session.Flush(); > scope.Complete(); > > } > > If run this code i am getting the exception "The operation is not > valid for the current state of the enlistment" after the call to > scope.Complete method. > > If i print the HashCode of the transactions they all look different. > That means is > > NHibernate not enlisting in the existing transaction? > > Any help is greatly appreciated.
-- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
