Fetch output from tJDBCRow component of Talend

Question

Hi,

I have this job, my input file data contains a lot of sql statement like DELETE, UPDATE, INSERT etc., and is separated by semicolon(;).

I want to fetch the result of the final number of rows affected by the query. I tried doing this, by selecting “Propagate QUERY's recordset” in the advanced settings of tJDBCRow component.

But when I am trying to execute this job its throwing me the following error: 

The executeQuery method must return a result set

Can someone help me out, in fetching the output for each statement? Thank you.

Answer 1

I guess, in this scenario, you can make use of tParseRecordSet component to extract info from the returned recordset. Then you need to write the query in order to fetch the total number of records updated.

Below are the screenshots of how I arranged my components to get the desired result:

In the component tab of the tJDBCRow component type in the query as shown:

In the component tab of tParseRecordSet component, add the below details in order to fetch the number of lines from the resultant data:

Hope this helps!

Get your Talend certification today to become certified professional.

Thanks.