BizTalk Server Orchestration - Write to db and transaction type

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Orchestration > September 2005 > Write to db and transaction type





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Write to db and transaction type
pez

2005-09-07, 7:48 am

Hi

I have an orchestration that first writes values to a database. Later in the
orchestration i update these values using another stored procedure. The
problem is that the update doesn't always work. I'm not sure way but one
theory is that the database row havn't been created yet when i try to update
it. Is this solved by using transaction types in scopes?

Thanks
pez

2005-09-09, 7:49 am

Hmm, can anyone at least give me an indication that I am on the right way
here...?

"pez" wrote:

> Hi
>
> I have an orchestration that first writes values to a database. Later in the
> orchestration i update these values using another stored procedure. The
> problem is that the update doesn't always work. I'm not sure way but one
> theory is that the database row havn't been created yet when i try to update
> it. Is this solved by using transaction types in scopes?
>
> Thanks

Matt Milner

2005-09-09, 5:52 pm

Try using Delivery Notification on the first send. This should allow you to
know that your first message has been delivered before you get to sending
the second.

Matt


"pez" <pez@discussions.microsoft.com> wrote in message
news:BC7E4180-60AD-4ACE-B465-0AD3D9C75829@microsoft.com...[vbcol=seagreen]
> Hmm, can anyone at least give me an indication that I am on the right way
> here...?
>
> "pez" wrote:
>


pez

2005-09-09, 5:52 pm

How do I do that?

"Matt Milner" wrote:

> Try using Delivery Notification on the first send. This should allow you to
> know that your first message has been delivered before you get to sending
> the second.
>
> Matt
>
>
> "pez" <pez@discussions.microsoft.com> wrote in message
> news:BC7E4180-60AD-4ACE-B465-0AD3D9C75829@microsoft.com...
>
>
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com