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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

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

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

    Posted Sat June 16, 2007 09:53 AM

    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


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


  • 2.  RE: batch insert using two different local transaction connection in a flow service

    Posted Sat June 16, 2007 06:54 PM

    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


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


  • 3.  RE: batch insert using two different local transaction connection in a flow service

    Posted Sun June 17, 2007 08:02 PM

    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.


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


  • 4.  RE: batch insert using two different local transaction connection in a flow service

    Posted Tue June 19, 2007 04:47 AM

    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…


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


  • 5.  RE: batch insert using two different local transaction connection in a flow service

    Posted Sat October 18, 2008 02:24 PM

    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


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


Related Content