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

problem with LOOP on jdbc adapter service result

  • 1.  problem with LOOP on jdbc adapter service result

    Posted Wed April 14, 2010 07:54 PM

    I need some help here, I have a JDBC Adpater service that returns a few rows, I need to loop through these rows, and map each row to a document and then publish that document, so if I have 3 rows returned from db, then 3 documents get published.

    I have trouble with the LOOP, if I do not put the LOOP in there, only one docuement gets published, but if I add LOOP, then nothing gets published at all. BTW, I am using 7.1.2

    I must have done something wrong (Obviousely).

    Any help greatly appreciated.


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


  • 2.  RE: problem with LOOP on jdbc adapter service result

    Posted Thu April 15, 2010 07:10 AM

    Its seems to be, it is not going inside loop…

    Loop over document list. [* hope u have added document list path in input array in properties]

    • add Map step under the loop (in this step, check your document list turned to document), do your mapping.

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


  • 3.  RE: problem with LOOP on jdbc adapter service result

    Posted Mon April 19, 2010 06:42 PM

    My Fault, I was looping through the result, instead of results of the OutPut. It is resolved, thanks to all.


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