EAI Transaction Service and Asynchronous Workflow
We have a requirement that we need to control transaction using EAI Transaction Service , BeginTransaction, EndTransaction, InTrasaction methods. It works fine if we call WF synchronously. This WF contains multi step update, upsert to base table from incoming SiebelMessage from external system.
We need to externalize EAI Transaction Service from calling inside Asynchronous WF step. Below are the steps:
1. Use BS to set "BeginTransaction' method of EAI Transaction Service
2. Invoke Async WF using Server Requests BS method Submit Request with mode 'DirectDb'
3. Set "EndTransaction' method of EAI Transaction Service.
Will above works?. if any update , upsert error on Async Worfkow, will transaction rollback?. if not any workaround?.