batch insert using two different local transaction connection in a flow service

, ,
1

Hi,
I am trying to use a two batch insert adapter services into two different oracle databases.
The adapter connections are using LOCAL Transactions and the adapter service has been invoked from a flow service.
The batch insert is failing with Adapter Runtime exception.
I am looking for a resolution. Appreciate your help in this regard.
IS / Adapter Details are:-
IS Ver 6.5
JDBC Ver 6.5
Fixes:
JDBC_6-5_Fix1
JDBC_6-5_Fix4
JDBC_6-5_Fix6
JDBC_6-5_Fix7
Thanks,
Venkat

2

Venkat,

Can you post the exact error dump that you are getting in the logs?? Also let us know your service configurations of the batch insert AS…so that users can assist you in better.

HTH,
RMG

3

It would be helpful if you post the error message given in the exception.

You cannot use two different local_transaction connections in a single transaction. One of the connections would need to be XA.

4

Thanks for the update reamon… now am not getting any error but the IS is going for toss when I run a batch insert of 2 local transaction…

5

Hey Venkat,

Pls can i know how you solved the problem; i too have same problem… i need to send large data to both database… using batch insert… its going well in first db but dev hangs… when i chk only 100 records are there in 2nd db.

Regards
Shaik