twaitforsql and java.sql.SQLException: Result set after last row

borrisbeck — Thu, 19 Sep 2019 16:00:25 GMT

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'

thanks

Re: twaitforsql and java.sql.SQLException: Result set after last row

fdenis — Fri, 20 Sep 2019 12:42:31 GMT

use count(*) in place of 1 then test value into a tmap then use tflow to iterate tu link to your job.

topic Re: twaitforsql and java.sql.SQLException: Result set after last row in Talend Studio

twaitforsql and java.sql.SQLException: Result set after last row

Re: twaitforsql and java.sql.SQLException: Result set after last row