updating huge data in database SQL using JDBC adaptor

[Former Member]

Hi All,

I have a scenario of IDOC to JDBC.

IDOC contains huge amount of data i.e. 50000 records in a single idoc

But when it is updating in SQL, it is updating one by one.

To insert records one by one in SQ,L is taking lot of time .

Kindly suggest me a way how can I insert all records in 1 shot in database.

Regards,

Narendra Goyal

[Former Member]

Is this only about mass-updating records ? How complex the WHERE clause is for this statement ? I do not understand how you end up with n single SQL statement in your scenario

Rgds

Chris

[Former Member]

What is your receiver JDBC message structure?

You should have multiple access nodes with in one statement node.

Thanks

Jai

[Former Member]

yes, It has multiple access nodes

Edited by: Narendra GSTIT on Oct 4, 2010 3:13 PM

[Former Member]

multilpe access nodes means a very complex SQL statement anyway (if you had to write it in native SQL), doesn't it ? Have you tried splitting into multiple submsgs and/or use the "batch mode" feature of the JDBC adapter ?

Chris