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
Expand all | Collapse all

Control transaction in flow service

  • 1.  Control transaction in flow service

    Posted Wed September 09, 2009 12:16 PM

    Hi all experts,

    Now i meet a problem bellow.
    I have 2 flow services.
    Service A update about 200 records in database.
    Service B update record No.1 in 200 records that service B updating.
    Details:
    When service A update record No.1, system automatic call service B to update record No.1.

      But because of service B must wait till service A completed(service A has locked record No1) so sometime service B is time out.
    

    Now i want to update flow service A so that it can commit transaction and unlock record No1. as soon as it finishes update record No1. Currently, after it finishes update 200 records, it unlocks record No.1.

    Now i am using JDBC Adapter 6.5. So can anybody give me the way to control transaction in flow service?. i have try to use pub.art.transaction:startTransaction and pub.art.transaction:commitTransaction but it seem wrong.

    Please help.

    Thanks you.

    Regards,
    TanNM


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 2.  RE: Control transaction in flow service

    Posted Sun September 20, 2009 09:36 PM

    startTransaction and commitTransaction are the correct services to use…did u check if the transaction name is the same when both these services are called…You might want give the transaction name as an input to both these services, though I believe its an optional field…


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods