I am sending a messaging within an orchestration via submitSync to a BizTalk
port that implement the SQL Adapter.  The message can have n number of exec
statements for the stated stored proc.

Is the work performed by the SQL Adapter transactional (will all the execute
statements commit or if one fails will they all abort)?  Does the
transactional settings on the submitSync component have any bearing on how
the SQL adapter performs its work?

TIA

[ Post a follow-up to this message ]

It should all be running inside a transaction and roll back if there is a
failure.  Calling submit or submitsync should not effect this either way.
All submitsync should do is block the submit call until the transport
returns a success or failure.

Larry Franks

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| From: "K. Zeronik" <kylezmsdn@nncgroup.com>
| Subject: BizTalk 2002 SQL Adapter Transactional?
| Date: Thu, 4 Mar 2004 20:08:19 -0500
| Lines: 12
| Organization: NNC Group
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <eRjBa5kAEHA.2660@TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.biztalk.orchestration
| NNTP-Posting-Host: cvx01-634.sfo.wenet.net 206.169.250.126
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.orchestration:5110
| X-Tomcat-NG: microsoft.public.biztalk.orchestration
|
| I am sending a messaging within an orchestration via submitSync to a
BizTalk
| port that implement the SQL Adapter.  The message can have n number of
exec
| statements for the stated stored proc.
|
| Is the work performed by the SQL Adapter transactional (will all the
execute
| statements commit or if one fails will they all abort)?  Does the
| transactional settings on the submitSync component have any bearing on how
| the SQL adapter performs its work?
|
| TIA
|
|
|

[ Post a follow-up to this message ]