|
Home > Archive > BizTalk Server General > May 2004 > Transaction Handling
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 |
Transaction Handling
|
|
|
| Does anyone know whether BizTalk will commit data on a
record basis or batch basis into a table? That is, if it
encountered any problem, will it rollback all previous
records or will just terminate at that point with some
records already inserted into a table?
Thanks in advanced.
| |
| Matt Milner 2004-04-30, 1:37 pm |
| If you are using update grams, you can put all the updates/inserts into a
sync block and this gets put into a transaction. I belive you might be able
to use an atomic scope to encapsulate your sends in a transaction as well,
but you might want to be careful how much you put in there as it may affect
your scalability.
Matt
"tsh" <anonymous@discussions.microsoft.com> wrote in message
news:679501c42e96$22522f40$a301280a@phx.gbl...
> Does anyone know whether BizTalk will commit data on a
> record basis or batch basis into a table? That is, if it
> encountered any problem, will it rollback all previous
> records or will just terminate at that point with some
> records already inserted into a table?
>
> Thanks in advanced.
| |
| Iuliu Rus 2004-05-25, 4:37 pm |
| It depends on the adapter you use. The adapters usually submit batches.
They are rolled back if something fails, but the adapters will filter out
whatever failed and submit again.
|
|
|
|
|