Transaction already active.

[shawn reagan]

Hello,
I'm still getting used to OpenAccess and have run into a problem.  I'm sure it has to do with the way i'm implementing things.  Here it goes.  I have an ASP.NET website using OpenAccess.  We have a screen where the user can edit a persistent object.  Now if they click "Save" an error happens which we handle and log, the problem I think is that the commit never gets called.  Now the user goes back to that screen and attempts to edit the persistent object again.  When they click Save the following error happens.  "Transaction already active".  Any ideas on where i'm messing this up?

Thank you

Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSave.Click
        Try
            ' Open a transaction and throw an exception
            Scope.Transaction.Begin()
            Throw New Exception
        Catch ex As Exception
            ' swallow the exception for testing purpose
        End Try

        Scope.Transaction.Begin() ' <-- This fails "Transaction already active"
        Scope.Transaction.Commit()
    End Sub

[shawn reagan]

I'm assuming I need to do something like the following, but I'm not exactly sure where to put it.  Would this go in the finally block of my "Try... Catch"?

If scope.Transaction.IsActive Then
 scope.Transaction.Rollback()
End If

[IT-Als]

Hi Shawn,

The construct I am using is this:

try
{
  if (!Scope.Transaction.IsActive)
    Scope.Transaction.Begin();
    /* Do some stuff */
    Scope.Transaction.Commit();
}
catch (Exception e)
{
  if (Scope.Transaction.IsActive)
    Scope.Transaction.Rollback();
}

If the "Do some stuff" part throws an exception the whole transaction (and any changes registered in a transaction that was already active) will be rolled back.

[Damyan Bogoev]

Hi Shawn,

You could use the approach proposed by Henrik. Additional information about handling of ITransaction instances in Telerik OpenAccess can be found here and here.

Greetings,
Damyan Bogoev
the Telerik team