Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
DotNet
acad.assignment.mngr
academic
adonet
aspnet
aspnet.announcements
aspnet.build.controls
aspnet.caching
aspnet.datagridcontrol
aspnet.mobile
aspnet.security
aspnet.webcontrols
aspnet.webservices
clr
compactframework
component_services
datatools
distributed_apps
drawing
faqs
framework
framework.wmi
general
internationalization
interop
languages.csharp
languages.jscript
languages.vb
languages.vb.controls
languages.vb.data
languages.vb.upgrade
languages.vc
languages.vc.libraries
myservices
odbcnet
performance
remoting
scripting
sdk
security
setup
vjsharp
vsa
webservi.enhancements
webservices
windowsforms
windowsforms.controls
winforms.databinding
winforms.designtime
xml
  
 
date: Tue, 9 May 2006 23:18:33 -0700,    group: microsoft.public.dotnet.distributed_apps        back       


Webservice Transaction Timeout   
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.
date: Tue, 9 May 2006 23:18:33 -0700   author:   Peter J. Hunter

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us