batch Insert|Update & XA_TRANSACTION

[Guest]

Hello,

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:
https://advantage.webmethods.com/advantage?targChanId=forums&tid=1610632002

For some reason, while a DB connection is defined as XA_TRANSACTION, you cannot build “batch” services such as BatchInsertSql. You will need to temporarily downgrade the connection to LOCAL_TRANSACTION while you create the service. Don’t forget to change it back afterwards.

But is this OK? What about the transaction handling?

[vilavd]

I believe that webMethods doesn’t support batch Insert/Update adapter services with XA_TRANSACTIONS.

It may work, but if there is a failure you may not be supported.

[ZA_VZ]

HI, I HAVE THE SAME PROBLEM, I HAVE TO USE TWO DIFFERENT DATABASES BUT ONE OF THEM HAVE TO USE BATCH INSERT.
I HEARD YOU COULD USED A MIX OF XA_TRANSACTION AND TO THE BATCH CONFIGURED IT WITH LOCAL_TRANSACTION.
IS THIS CORRECT?
THANKS!!