IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

batch Insert|Update & XA_TRANSACTION

  • 1.  batch Insert|Update & XA_TRANSACTION

    Posted Mon October 30, 2006 01:35 PM

    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

    But is this OK? What about the transaction handling?


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: batch Insert|Update & XA_TRANSACTION

    Posted Wed November 01, 2006 04:55 AM

    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.


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 3.  RE: batch Insert|Update & XA_TRANSACTION

    Posted Fri December 18, 2015 01:49 PM

    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!!


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


Related Content