Pinned topic UpdateAll operation using JDBC Adapter
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
anki1989 27000732S01 Post
Re: UpdateAll operation using JDBC Adapter2015-01-15T08:17:12ZThis is the accepted answer. This is the accepted answer.
Even I have the same requiremen but in WPS 7.0t. Can someone please guide me on how to perform UpdateAll using JDBC adapter?
TrushkinAndrey 270003U6WV2 Posts
Ответ: Re: UpdateAll operation using JDBC Adapter2015-01-15T08:43:36ZThis is the accepted answer. This is the accepted answer.
- anki1989 27000732S0
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.