explicit transaction

I am working with 2 different DB’s

DB 1 ------- insert service
DB 2 ------- update service

without using XA transaction how to handle ?

If we go for Explicit trasaction.
If any service fails it should Rollback.

Do we need to give two start and commit Transactions
If so in catch block we need to give one rollback or two rollbacks?


If the 2 operations need to be treated as 1 (both succeed or both rollback) then you must use XA.