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
TrushkinAndrey 270003U6WV2 PostsACCEPTED ANSWER
Ответ: Re: UpdateAll operation using JDBC Adapter2015-01-15T08:43:36Z in response to anki1989
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.