Fetch output from tJDBCRow component of Talend

0 votes

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(;).

imageI 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.

May 1, 2018 in Talend by misc.edu04
• 1,420 points
302 views

1 answer to this question.

0 votes

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:

image

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

image

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

image

Hope this helps!

answered May 1, 2018 by geek.erkami
• 2,640 points

Related Questions In Talend

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Specifying the number of Rows Processed in Talend

Hi, you can try using tSampleRow component ...READ MORE

answered Apr 14, 2018 in Talend by code.reaper12
• 3,450 points
106 views
0 votes
1 answer

Looping through all the schemas in Talend

It is really simple to make tOracleInput ...READ MORE

answered Apr 10, 2018 in Talend by code.reaper12
• 3,450 points
127 views
0 votes
1 answer
0 votes
2 answers
0 votes
1 answer

Special issues while using WSO2

To choose an ESB for integration, you ...READ MORE

answered Apr 9, 2018 in Talend by anto.trigg4
• 3,420 points
83 views
0 votes
1 answer

Accessing Talend Project from SVN

According to my understanding, there are two ...READ MORE

answered Apr 9, 2018 in Talend by geek.erkami
• 2,640 points
225 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

Regarding your first issue, tWaitForFile component provides ...READ MORE

answered Apr 10, 2018 in Talend by geek.erkami
• 2,640 points
350 views