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

[borrisbeck]

Hi

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

mj

[fdenis]

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