Topic
  • 2 replies
  • Latest Post - ‏2015-01-15T08:43:36Z by TrushkinAndrey
JaydeepSapariya
JaydeepSapariya
1 Post

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

    Re: UpdateAll operation using JDBC Adapter

    ‏2015-01-15T08:17:12Z  

    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

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

    ‏2015-01-15T08:43:36Z  
    • anki1989
    • ‏2015-01-15T08:17:12Z

    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.

    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