HighTechTalks DotNet Forums  

Webservice Transaction Timeout

Dotnet Distributed Applications microsoft.public.dotnet.distributed_apps


Discuss Webservice Transaction Timeout in the Dotnet Distributed Applications forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Peter J. Hunter
 
Posts: n/a

Default Webservice Transaction Timeout - 05-10-2006 , 02:18 AM






I have a VB webservice that performs a lengthly update on several SQL tables. I tried the <webmethod(transactionOption:=RequiresNew)> syntax and continually encountered a transaction timeout after 60 or so seconds.

I then removed the TransactionOption from the method declaration and added the following code in the body of the method:

Dim myTrans As New TransactionAttribute(TransactionOption.RequiresNew )
myTrans.Timeout = 800
myTrans.Isolation = TransactionIsolationLevel.Serializable

This seems to work. I would just like validation from someone that it is equlivant to the webmethod declaration approach. Thanks.

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.