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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Jdbc adapters and connections

    Posted 11/24/05 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 11/29/05 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 11/30/05 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 11/30/05 11:31 AM