| larry franks 2004-03-11, 10:43 pm |
| 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
|
|
|
|