I have a scenario where I need to run a set of jobs depending on a output of a sql, so i'm using twaitforsqldata. the SQL has to be executed only once, only if it returns a row, the flow should proceed otherwise it has to skip all jobs. when i use the below sql in twaitforsqldata, i'm getting the error "java.sql.SQLException: Result set after last row", when i searched it seems like java produces this error when the sql returns no rows. Even when there is a option to check for Zero rows in twaitforsqldata, why am I getting this error? and is there any way to handle this in twaitforsqldata ( at this moment i don't want to use a java component)
SELECT '1' col FROM table1 WHERE (select somefunction('dfd') from dual) = 'YES'
Tag as "solved" for others! Kudos to thanks!
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema