Trouble with Transation timeouts

Trouble with Transation timeouts

Postby edstaffin » Fri 16 Jul 2010 13:51

Hi,
I have been having trouble with the following code. I am trying to a large transaction over a slow connection that takes approximately 35 minutes to run. I end up getting a Transaction timeout error when I do the oScope.complete. Seems to me like I set the timeout to 1 hour+ but I'm still getting a timeout. Any ideas?
Thanks ... Ed

Code: Select all
Using oScope As New TransactionScope TransactionScopeOption.Required, New TimeSpan(1, 1, 1))
            Dim db As New MyDataContext
            ' do stuff
            db.SubmitChanges()
            oScope.Complete()
End Using
edstaffin
 
Posts: 43
Joined: Mon 13 Oct 2008 13:23

Postby AndreyR » Wed 21 Jul 2010 11:25

I have made a simple test and timeout worked as expected.
Could you please make a small test project illustrating the error, if possible?
One more thing: is there any InnerException? Possibly the problem is not associated with the timeout.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby edstaffin » Wed 21 Jul 2010 12:09

Don't think there is an inner exception. When I run it without ANY transaction it runs without error.
edstaffin
 
Posts: 43
Joined: Mon 13 Oct 2008 13:23

Postby AndreyR » Thu 22 Jul 2010 12:22

Thank you for the clarification. Waiting for the test project.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle