Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2015-01-15T08:43:36Z by TrushkinAndrey
JaydeepSapariya
JaydeepSapariya
1 Post
ACCEPTED ANSWER

Pinned topic UpdateAll operation using JDBC Adapter

‏2012-08-01T13:12:28Z |
Hi,
I am using Websphere ESB 6.2. As per my requirement i have to update bulk records in Oracle DB. As don't have updateAll() operation with JDBC adapter, i am unable to update bulk records in DB.

Currently i am using FAN out recursively component functionality to update records in DB. Ideally this is not an good way & it will impact performance as well.

Please need your suggestion to update bulk records. Thanks in advance.

Thanks & Regards
Jaydeep Sapariya
  • anki1989
    anki1989
    1 Post
    ACCEPTED ANSWER

    Re: UpdateAll operation using JDBC Adapter

    ‏2015-01-15T08:17:12Z  in response to JaydeepSapariya

    Hi All,

     

    Even I have the same requiremen but in WPS 7.0t. Can someone please guide me on how to perform UpdateAll using JDBC adapter?

     

    Thanks.

    • TrushkinAndrey
      TrushkinAndrey
      2 Posts
      ACCEPTED ANSWER

      Ответ: Re: UpdateAll operation using JDBC Adapter

      ‏2015-01-15T08:43:36Z  in response to anki1989

      Hi.

       

      Bulk record updating using JDBC Adapter is not a good practice, because it's performance is not very good for such operation. The best way for it is implementing stored procedure in DB and call it using java code from custom mediation primitive.

       

      Regards,

      Andrey