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 multiple records at a time

    Posted Tue May 03, 2005 12:28 PM

    Hi,
    I have to insert overall 50,000 records, with 250 records everytime(batchwise insertion).I don’t want to call the insert adapter for every record.I will call the start and commit transaction services, before and after the 50000 records are inserted into database resp.

    Can Java stored procedures help me in achieving this.
    Can anyone help me in this.

    Thanks
    Murali


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


  • 2.  RE: Insert multiple records at a time

    Posted Tue May 03, 2005 02:37 PM

    Murali,
    Yes you can use stored procedures or the JDBC2.0 addBatch methods to execute a batch of sql commands.

    ~tS


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


  • 3.  RE: Insert multiple records at a time

    Posted Wed May 04, 2005 03:12 AM

    Saleem,
    Thanks for your mesg.
    In webMethods, do we have any option for batch methods in jdbc adapter.

    thanks
    murali


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


  • 4.  RE: Insert multiple records at a time

    Posted Mon May 09, 2005 10:32 AM

    Hi Muralidhar,
    WMJDBC adapter has adapter service for batch insert, which takes documentlist as input.

    Hi Wm Experts,
    Even i also have a scenario, where records are to be inserted into database in batch and i have implemented it using batch insert Adapter service(it’s working fine),But i have a query about the performance of both i.e.

    Out of Stored Procedure/Batch Insert Adapter service which one is efficient in terms of performance??

    My environment : WM6.1,JDBC Adapter6.0.3,Solaris9.

    Regards,
    Puneet Saxena


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


Related Content