I forgot to paste the message :P,

"[NHibernate.TransactionException]{"Begin failed with SQL exception"}
The connection is already part of a local or distributed transaction"

Is it a Oracle related issue?

best regards

On 2 dic, 12:31, Fabio Maulo <[email protected]> wrote:
> A stack trace without the exception message is more than enough.
> Thanks.
>
>
>
> On Thu, Dec 2, 2010 at 12:54 PM, rodri_ogri <[email protected]> wrote:
> > Hi all,
>
> > I have tried something I thought was fixed on this version, it is the
> > capability to work with TransactionScope and NH transactions with an
> > Oracle 11G DB.
>
> > This is the test I have done:
>
> > [TestMethod]
> >        public void TransactionScope_Test()
> >        {
> >            bool vTransactionInitialized = false;
>
> >            using(TransactionScope vTx = new
> > TransactionScope(TransactionScopeOption.Required))
> >            {
> >                using (ISession vSession =
> > SessionFactory.OpenSession())
> >                {
> >                    using(ITransaction vNHTransaction =
> > vSession.BeginTransaction())
> >                    {
> >                        try
> >                            {
> >                            vTransactionInitialized = true;
> >                            vNHTransaction.Commit();
> >                            }
> >                            catch (Exception)
> >                            {
> >                            vNHTransaction.Rollback();
> >                            }
> >                    }
> >                }
> >                vTx.Complete();
> >            }
>
> >            Assert.IsTrue(vTransactionInitialized);
> >        }
>
> > It throws a NHibernate.TransactionException with the following trace:
>
> > Oracle.DataAccess.Client.OracleConnection.BeginTransaction(IsolationLevel
> > isolationLevel)
> > Oracle.DataAccess.Client.OracleConnection.BeginDbTransaction(IsolationLevel
> > isolationLevel)
>
> > System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction()
> > NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel
> > isolationLevel) in d:\CSharp\NH\nhibernate\src\NHibernate\Transaction
> > \AdoTransaction.cs: line 130
> > NHibernate.Transaction.AdoTransaction.Begin(IsolationLevel
> > isolationLevel) in d:\CSharp\NH\nhibernate\src\NHibernate\Transaction
> > \AdoTransaction.cs: line 145
> > NHibernate.Transaction.AdoTransaction.Begin() in d:\CSharp\NH
> > \nhibernate\src\NHibernate\Transaction\AdoTransaction.cs: line 94
> > NHibernate.AdoNet.ConnectionManager.BeginTransaction() in d:\CSharp\NH
> > \nhibernate\src\NHibernate\AdoNet\ConnectionManager.cs: line 324
> > NHibernate.Impl.SessionImpl.BeginTransaction() in d:\CSharp\NH
> > \nhibernate\src\NHibernate\Impl\SessionImpl.cs: line 1437
>
> > Is it possible to have it fixed on this new version?
>
> > best regards
>
> > Rodrigo
>
> > --
> > 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]<nhusers%[email protected]>
> > .
> > For more options, visit this group at
> >http://groups.google.com/group/nhusers?hl=en.
>
> --
> Fabio Maulo

-- 
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.

Reply via email to