topic Re: [resolved] Input to a tJDBCInput component in Talend Studio

[resolved] Input to a tJDBCInput component

Anonymous — Fri, 19 Jul 2013 13:52:26 GMT

I am fetching a list of IDs using a tJDBCInput component, processing it in the tJavaRow. Based on some condition I need to fetch the corresponding row from the database, for which I have defined another tJDBCInput component.
But I am not able to connect to that tJDBCInput using Main/Iterate. As I see, the first JDBC Input component will fetch ID row by row, which I am checking for some condition in the tJavaRow, and on success, I need to fetch data from another query using this ID.
If I give a Run If component after tJavaRow, all the rows from first query are fetched and then the Run If executes.
How is it possible for the second query to use the output of the first query? I tried using tJDBCRow, but it won't give any output (as mentioned in the documentation).

Re: [resolved] Input to a tJDBCInput component

Anonymous — Fri, 19 Jul 2013 21:49:58 GMT

Will joining your tJDBCInputs on ID with a tMap work for you?

Re: [resolved] Input to a tJDBCInput component

alevy — Sat, 20 Jul 2013 13:10:23 GMT

You'll need the main from tJavaRow to go to tFlowToIterate then iterate to tJava (empty) and the RunIf to your second tJDBCInput.
You could also connect your first tJDBCInput directly to tFlowToIterate and have your processing in the tJava instead of tJavaRow.