topic Re: Cycle insert - Second Insert waiting for response from first Insert in Talend Studio

Cycle insert - Second Insert waiting for response from first Insert

Anonymous — Mon, 17 Jun 2013 13:23:26 GMT

hello,
I'm not sure how to solve the following situation in Talend.
I insert a category via Webservice, getting the new ID for this category as response. Then I insert the next category with the new ID received as parent_ID.
How can I make sure that I received the previous inserted new ID bevor inserting the next category.
"I need some information at the start of job from the end of the job"
thank you!
Robert

Re: Cycle insert - Second Insert waiting for response from first Insert

Anonymous — Mon, 17 Jun 2013 15:23:43 GMT

Break your job into two pieces connected with onSubJobOK.
1st piece will call the web service and save the response in a context var. A tJavaRow after your tWebService is probably the easy way to do this.
2nd piece will check that context var to assign the ID and insert.

Re: Cycle insert - Second Insert waiting for response from first Insert

Anonymous — Mon, 17 Jun 2013 18:59:21 GMT

thank you for your answer!

I think my explanation was not clear enough.
I'm getting the categories from a local table writting them to a remote table with a webservice, receiving an "remote" ID for the category
After each insert I do an update to the local category table inserting the remote_ID.
The remote_ID is the parent_ID on the remote table for the following categories.
I can not see how to solve that with splitting the job.
Thank you very much!
regards,
robert