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,450 points
3,364 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!

Get your Talend certification today to become certified professional.

Thanks.

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

Related Questions In Talend

0 votes
1 answer
0 votes
0 answers
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,500 points
1,857 views
0 votes
1 answer

Looping through all the schemas in Talend

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

answered Apr 11, 2018 in Talend by code.reaper12
• 3,500 points
1,902 views
+1 vote
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,440 points
827 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,680 points
1,571 views
0 votes
1 answer

tWaitForFile component insufficiency in Talend

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

answered Apr 11, 2018 in Talend by geek.erkami
• 2,680 points
2,510 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP