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
  • 1.  Insert Data into Database

    Posted Thu May 31, 2012 01:49 PM

    I have one document contain Name and Age,I have one datase which has two columns name and age, could anyone please tell me how can I read data and insert into database. I have 10 record in my document.Thanks in Advance.


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


  • 2.  RE: Insert Data into Database

    Posted Fri June 01, 2012 07:33 AM

    Hi Ashish,

    –First you have to create the Adapter connection for that database .
    –second you have to create the adapter service(insert Adapter service) for that particular Table and you need to mention there your inputs.
    –Third you have to create flow service : in that apply loop to iterate you Document and user adapter service inside that …

    For details explanation see the [h=3]webMethods JDBC Adapter User Guide…or webMethods Developer guide…[/h]


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


  • 3.  RE: Insert Data into Database

    Posted Tue June 05, 2012 11:06 AM

    Better to you use batch insert with local transaction


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