topic Iterate over java array list and update database in Talend Studio

Iterate over java array list and update database

Anonymous — Fri, 06 Feb 2015 02:50:13 GMT

Hi,
I have a scenario where I need to iterate over java arraylist and then I need to update database table for each entry in the arraylist. Fore each record I need to lookup other tables as well. Therefore the iterated record should be passed through a tMap as well. Can someone please let me know what are the components and how to arrange them in order to get this done?
Thanks and Regards,
Asanka.

Re: Iterate over java array list and update database

Anonymous — Fri, 06 Feb 2015 04:06:28 GMT

on tJava component, get each item from arrayList and append each item to a string, the final string looks like:
...
String items="a,b,c,...";
And then, store the string to a global var or context var for used later.
On next subjob, generate this string on tFixedFlowInput (get the value of global var or context var), normalize the input string with tNormalize component to generate multiple lines, and then map the lookup data.
tJava
|
onsubjobok
|
tFixedFlowInput--main--tNormalize--main--tMap--main--tDatabaseOutputComponent
|
lookup
|
table
Best regards
Shong

Re: Iterate over java array list and update database

Anonymous — Fri, 06 Feb 2015 05:28:01 GMT

Hi Shong,
Thanks for your reply. But this wont help in my scenario as there are millions of records in the arraylist and those records represents a custom object (not strings). Is there a way to iterate the list and process each record (each item of the list) through tMap?
Thanks and Regards,
Asanka.

Re: Iterate over java array list and update database

Anonymous — Sun, 08 Feb 2015 09:42:32 GMT

Hi Asanka
This is just a simple example with basic data type. For complex type, like custom object in you case, you can use tJavaFlex to iterate the list and process each record.
BR
Shong