Transaction based DB updates

e...@ee.demon.co.uk

unread,

Apr 25, 2006, 3:53:49 PM4/25/06

to

Hi all,

How do Biztalk developers normally handle multiple DB updates from within
.net components that are being called from a Biztalk orchestration?

Receive PO
|
Expression Update SQL Via .Net Method call
|
Expression Update SQL Via another .Net Method call
|
Stop

I need to be able to rollback the transaction preformed in the earlier
stages.

Surly someone in this news group knows the best way of handing multiple DB
updates from within .net components that are being called from a Biztalk
orchestration?

The problem with putting into a store procedure is that all of the
visibility of the process is lost, i.e. I might as well use DTS!

Thanks in advance

Simon

Matt Milner

unread,

Apr 25, 2006, 9:35:11 PM4/25/06

to

You can wrap your .NET code into serviced components and then take advantage
of the atomic scope shape in the orchestration. This will enroll your
orchestration state persistence and the serviced component code into a
single transaction.

matt

<e...@ee.demon.co.uk> wrote in message
news:444e7f60$0$8021$c3e...@news.astraweb.com...

e...@ee.demon.co.uk

unread,

Apr 27, 2006, 2:24:38 AM4/27/06

to

On 26-Apr-2006, "Matt Milner" <matt.milner@m3technologypartners dot com>
wrote:

Thanks matt.

Have you actually used this technique?

Do you know where I could find a example.

Thanks in advanced

Simon

e...@ee.demon.co.uk

unread,

Apr 27, 2006, 2:31:48 AM4/27/06

to

On 26-Apr-2006, "Matt Milner" <matt.milner@m3technologypartners dot com>
wrote:

Thanks matt.

I was sure someone must know how to implement transactions in this scenario.

Would you go about it this way?

I am tying to sell the use of Biztalk as appose to the current DTS so the
orchestrations need to be quite visual, i.e. I cannot just locate all the
functionality into a stored procedure.

e...@ee.demon.co.uk

unread,

Apr 27, 2006, 4:20:50 PM4/27/06

to

Thanks

I was sure someone must know how to implement transactions in this scenario.

Would you go about it this way?

I am tying to sell the use of Biztalk as appose to the current DTS so the
orchestrations need to be quite visual, i.e. I cannot just locate all the
functionality into a stored procedure.

Have you actually used this technique?

Thanks in advanced

Simon

Matt Milner

unread,

Apr 29, 2006, 12:14:10 AM4/29/06

to

I'm traveling right now, but will try to post a bit more this weekend or
early next week with a sample if possible.

Matt

<e...@ee.demon.co.uk> wrote in message
news:44506678$0$32067$c3e...@news.astraweb.com...

Madhup

unread,

May 26, 2006, 7:48:02 AM5/26/06

to

Hi Simon

I am facing a similar problem. The only difference is that my COM+
Components and Database Servers are in different domain. I am using the
atomic transaction and trying to pass this to Serviced Components but it is
failing.
Your help to resolve this problem will be highly appreciated.

Thanks in advance
Madhup.

Paul Somers

unread,

Aug 1, 2006, 5:57:25 AM8/1/06

to

Hi,

I have used the serviced .net components registered in transaction server,
with multiple SQL statements, as well as multiple oracle statements, both
work when set up correctly as a DTC transaction, within an atomic scope.

EG: 2 separate sprocs are called from BizTalk that do updates, and the 3rd
separate call fails, all 3 roll back.

Works a treat.

"Madhup" <Mad...@discussions.microsoft.com> wrote in message
news:3F1B2435-4D3B-465B...@microsoft.com...