AdoWorkBatchService and multiple distributed transactions.

Apr 4, 2008 at 11:18 AM
Hi,
Is it possible to run paralel activities, that do transaction work on more than one durable resourse with escalating local transaction on Oracle with ODP.NET.
10x
Coordinator
Apr 18, 2008 at 10:54 AM
Hi there,

Oracle does not support the concept of Promotable Single Phase Enlistment (PSPE) which allows a local transaction to escalate to a distributed transaction. By default TransactionScope will always create a distributed transaction for Oracle databases. In WFTools we use a performance optimisation that allows a local transaction to be used but subsequently forsake the ability to promote to a distributed transaction.

This behaviour can be tweaked by changing the constructor you use when creating the AdoWorkBatchService.

Hope that answers your question,

Cheers,

Dean