I have flow that inserts data into DB. This flow uses two diffrent connection pools, so both pools are set to use XA_TRANSACTION. It uses batchInsert services within transaction and I got error during creation/refresh of the batch service, cos batchIsert can be used only with LOCAL_TRANSACTION.
I have done exactly the same as descibed here:
But is this OK? What about the transaction handling?