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?

Regards
Kumar

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