|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How are transactions managed for web servicesHi,
How are transactions managed when publishing stored procedures as web services? Does SQLXML automatically commit the transaction if the stored procedure succeeded and rollback if it failed? Thanks. Hello McGeeky,
> How are transactions managed when publishing stored procedures as web For SQL Server 2005 using SOAP endpoints: Nope. Layering a Web Service on > services? Does SQLXML automatically commit the transaction if the > stored procedure succeeded and rollback if it failed? top of a stored proc doesn't change how the stored proc behaves, you still need to manage the transactions correctly and internally to your own code. The new TRY-CATCH syntax makes that easier, of course. Thank you, Kent Tegels DevelopMentor http://staff.develop.com/ktegels/ I am using SQL Server 2000 with SQLXML and MS Soap Toolkit. There is not
opportunity to manage the transactions directly so I am presuming that SQLXML does it automatically. Show quoteHide quote "Kent Tegels" <kteg***@develop.com> wrote in message news:b87ad7411b5a8c7bd5231b417cf@news.microsoft.com... > Hello McGeeky, > >> How are transactions managed when publishing stored procedures as web >> services? Does SQLXML automatically commit the transaction if the >> stored procedure succeeded and rollback if it failed? > > For SQL Server 2005 using SOAP endpoints: Nope. Layering a Web Service on > top of a stored proc doesn't change how the stored proc behaves, you still > need to manage the transactions correctly and internally to your own code. > The new TRY-CATCH syntax makes that easier, of course. > > Thank you, > Kent Tegels > DevelopMentor > http://staff.develop.com/ktegels/ > > Transaction management is internal to the webservice endpoint. There is no
support for cross-service call transactions. If you want to build such a system, you will have to build your own multi-level transaction management scheme. Best regards Michael Show quoteHide quote "McGeeky" <a***@anon.com> wrote in message news:edNPGj37FHA.3760@TK2MSFTNGP14.phx.gbl... >I am using SQL Server 2000 with SQLXML and MS Soap Toolkit. There is not >opportunity to manage the transactions directly so I am presuming that >SQLXML does it automatically. > > -- > McGeeky > http://mcgeeky.blogspot.com > > > "Kent Tegels" <kteg***@develop.com> wrote in message > news:b87ad7411b5a8c7bd5231b417cf@news.microsoft.com... >> Hello McGeeky, >> >>> How are transactions managed when publishing stored procedures as web >>> services? Does SQLXML automatically commit the transaction if the >>> stored procedure succeeded and rollback if it failed? >> >> For SQL Server 2005 using SOAP endpoints: Nope. Layering a Web Service on >> top of a stored proc doesn't change how the stored proc behaves, you >> still need to manage the transactions correctly and internally to your >> own code. The new TRY-CATCH syntax makes that easier, of course. >> >> Thank you, >> Kent Tegels >> DevelopMentor >> http://staff.develop.com/ktegels/ >> >> > > Hi Michael. Having the transaction management internal to the webservice is
absolutely ideal and music to my ears. I just wanted to confirm that this was so before pressing ahead with a large project. Thanks Show quoteHide quote "Michael Rys [MSFT]" <m***@online.microsoft.com> wrote in message news:OapnwiQAGHA.3864@TK2MSFTNGP12.phx.gbl... > Transaction management is internal to the webservice endpoint. There is no > support for cross-service call transactions. If you want to build such a > system, you will have to build your own multi-level transaction management > scheme. > > Best regards > Michael > > "McGeeky" <a***@anon.com> wrote in message > news:edNPGj37FHA.3760@TK2MSFTNGP14.phx.gbl... >>I am using SQL Server 2000 with SQLXML and MS Soap Toolkit. There is not >>opportunity to manage the transactions directly so I am presuming that >>SQLXML does it automatically. >> >> -- >> McGeeky >> http://mcgeeky.blogspot.com >> >> >> "Kent Tegels" <kteg***@develop.com> wrote in message >> news:b87ad7411b5a8c7bd5231b417cf@news.microsoft.com... >>> Hello McGeeky, >>> >>>> How are transactions managed when publishing stored procedures as web >>>> services? Does SQLXML automatically commit the transaction if the >>>> stored procedure succeeded and rollback if it failed? >>> >>> For SQL Server 2005 using SOAP endpoints: Nope. Layering a Web Service >>> on top of a stored proc doesn't change how the stored proc behaves, you >>> still need to manage the transactions correctly and internally to your >>> own code. The new TRY-CATCH syntax makes that easier, of course. >>> >>> Thank you, >>> Kent Tegels >>> DevelopMentor >>> http://staff.develop.com/ktegels/ >>> >>> >> >> > > Hi Michael. Can the transaction isolation level be changed in the stored
procedure? What isolation level does the web service use by default? Thanks. Show quoteHide quote "Michael Rys [MSFT]" <m***@online.microsoft.com> wrote in message news:OapnwiQAGHA.3864@TK2MSFTNGP12.phx.gbl... > Transaction management is internal to the webservice endpoint. There is no > support for cross-service call transactions. If you want to build such a > system, you will have to build your own multi-level transaction management > scheme. > > Best regards > Michael > > "McGeeky" <a***@anon.com> wrote in message > news:edNPGj37FHA.3760@TK2MSFTNGP14.phx.gbl... >>I am using SQL Server 2000 with SQLXML and MS Soap Toolkit. There is not >>opportunity to manage the transactions directly so I am presuming that >>SQLXML does it automatically. >> >> -- >> McGeeky >> http://mcgeeky.blogspot.com >> >> >> "Kent Tegels" <kteg***@develop.com> wrote in message >> news:b87ad7411b5a8c7bd5231b417cf@news.microsoft.com... >>> Hello McGeeky, >>> >>>> How are transactions managed when publishing stored procedures as web >>>> services? Does SQLXML automatically commit the transaction if the >>>> stored procedure succeeded and rollback if it failed? >>> >>> For SQL Server 2005 using SOAP endpoints: Nope. Layering a Web Service >>> on top of a stored proc doesn't change how the stored proc behaves, you >>> still need to manage the transactions correctly and internally to your >>> own code. The new TRY-CATCH syntax makes that easier, of course. >>> >>> Thank you, >>> Kent Tegels >>> DevelopMentor >>> http://staff.develop.com/ktegels/ >>> >>> >> >> > > I am not sure if you can control it via the webservices interface (I am not
the expert here), but I would assume that it uses per default what is set for the database... Best regards Michael Show quoteHide quote "McGeeky" <a***@anon.com> wrote in message news:%23Z%23KzBkAGHA.3456@TK2MSFTNGP11.phx.gbl... > Hi Michael. Can the transaction isolation level be changed in the stored > procedure? What isolation level does the web service use by default? > > Thanks. > > -- > McGeeky > http://mcgeeky.blogspot.com > > > "Michael Rys [MSFT]" <m***@online.microsoft.com> wrote in message > news:OapnwiQAGHA.3864@TK2MSFTNGP12.phx.gbl... >> Transaction management is internal to the webservice endpoint. There is >> no support for cross-service call transactions. If you want to build such >> a system, you will have to build your own multi-level transaction >> management scheme. >> >> Best regards >> Michael >> >> "McGeeky" <a***@anon.com> wrote in message >> news:edNPGj37FHA.3760@TK2MSFTNGP14.phx.gbl... >>>I am using SQL Server 2000 with SQLXML and MS Soap Toolkit. There is not >>>opportunity to manage the transactions directly so I am presuming that >>>SQLXML does it automatically. >>> >>> -- >>> McGeeky >>> http://mcgeeky.blogspot.com >>> >>> >>> "Kent Tegels" <kteg***@develop.com> wrote in message >>> news:b87ad7411b5a8c7bd5231b417cf@news.microsoft.com... >>>> Hello McGeeky, >>>> >>>>> How are transactions managed when publishing stored procedures as web >>>>> services? Does SQLXML automatically commit the transaction if the >>>>> stored procedure succeeded and rollback if it failed? >>>> >>>> For SQL Server 2005 using SOAP endpoints: Nope. Layering a Web Service >>>> on top of a stored proc doesn't change how the stored proc behaves, you >>>> still need to manage the transactions correctly and internally to your >>>> own code. The new TRY-CATCH syntax makes that easier, of course. >>>> >>>> Thank you, >>>> Kent Tegels >>>> DevelopMentor >>>> http://staff.develop.com/ktegels/ >>>> >>>> >>> >>> >> >> > >  
Other interesting topics
Query: Using dynamic XQuery expressions (urgent)
Getting Empty Tags Returned From The Server Return Value from SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class.Execute Confirm methodology or advise how to generate performance reports for eCommerce facility. xml-dml insert element with an attribute containig sql:variable Add perent element dynamic XML using for XML explicit Sequential vs. Simultaneous processing sending xml data from stored procedure trouble with annotated xsd mapping schemas |
|||||||||||||||||||||||
