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
  • 1.  Jdbc adapters and connections

    Posted Thu November 24, 2005 05:08 AM

    hai friends,
    it is an real time question.we had established two connections using jdbc adapters.ie connection1 and connection2.now we r using these connections in the flow service.if the transaction using connection1 is a success and the transcation using connection2 is a failure.what happens to the entire transcation whether it will be committed r rollback.The transcation types in both connections are no-transcations.
    advance thanks

    regards
    ravi


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


  • 2.  RE: Jdbc adapters and connections

    Posted Tue November 29, 2005 01:32 PM

    Hi Ravi
    Are these service (built on the two different connections)refering on the same table in the database. If so there would be an runtime error i guess or ie they do not refere to same table(source) then they will be commited.


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


  • 3.  RE: Jdbc adapters and connections

    Posted Wed November 30, 2005 11:27 AM

    Hi Ravi,
    ASAIK, irrespective of same table or different tables, in case error occurs after transaction starts(explicitly, using built-in-service;startTransaction), then whole transaction is rolled back.

    Regards,
    Puneet Saxena


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


  • 4.  RE: Jdbc adapters and connections

    Posted Wed November 30, 2005 11:31 AM