I need to read the records from a mysql table and for each row I need to execute 2 separate Java functions. This is what I did:
Tmysql -> tflowtoiterate ->(iterate) tjava1 -> (iterate) tjava2
The problem is that it executed all the rows in tjava1 but in tjava2 it executed some of the rows and not all of them. I tried putting them in the same tjava also did not work.. Any help would be appreciated.
Thanks mate, no errors received, the job executes till the end successfully. Here is a small description on my job:
(Tmysql) I read rows from Mysql Table X and (tflowtoiterate) for each row, (tjava1) insert the row in AS400/DB2 keyedDataQueue that inserts them in a table(Keyedqueue usually sends the key of each row to a dataqueue2 meaning it was inserted successfully), (tjava2) for each inserted row Delete the response from the response queue2 as it is no longer needed.
What happens in my case all the rows are being inserted successfully and for each row a response is created in dataqueue2 but when deleting the response, it is deleting some of them and not all of them (for each row).
e.g.: 40800 records inserted
30000 are deleted, sometimes 4000 only are deleted instead of 40800.
use tjavarow instead of tjava
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.