| Author |
How are transactions managed for web services
|
|
| McGeeky 2005-11-22, 7:23 am |
| Hi,
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.
--
McGeeky
http://mcgeeky.blogspot.com
| |
| Kent Tegels 2005-11-22, 9:23 am |
| 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/
| |
| McGeeky 2005-11-22, 11:23 am |
| 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" <ktegels@develop.com> wrote in message
news:b87ad7411b5a8c7
bd5231b417cf@news.microsoft.com...
> Hello McGeeky,
>
>
> 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/
>
>
| |
| Michael Rys [MSFT] 2005-12-14, 8:25 pm |
| 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" <anon@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" <ktegels@develop.com> wrote in message
> news:b87ad7411b5a8c7
bd5231b417cf@news.microsoft.com...
>
>
| |
| McGeeky 2005-12-15, 7:23 am |
| 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
--
McGeeky
http://mcgeeky.blogspot.com
"Michael Rys [MSFT]" <mrys@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" <anon@anon.com> wrote in message
> news:edNPGj37FHA.3760@TK2MSFTNGP14.phx.gbl...
>
>
| |
| McGeeky 2005-12-16, 7:23 am |
| 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]" <mrys@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" <anon@anon.com> wrote in message
> news:edNPGj37FHA.3760@TK2MSFTNGP14.phx.gbl...
>
>
| |
| Michael Rys [MSFT] 2005-12-17, 3:23 am |
| 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
"McGeeky" <anon@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]" <mrys@online.microsoft.com> wrote in message
> news:OapnwiQAGHA.3864@TK2MSFTNGP12.phx.gbl...
>
>
|
|
|
|