topic Re: The executeQuery method must return a result set in Talend Studio

The executeQuery method must return a result set

Anonymous — Sat, 16 Nov 2024 12:44:22 GMT

Hi everybody,
I'm sorry to create a new post but I can't find an answer to my problem.
I have a tMSSqlInput with a query.
When I run the query I have the following error message:
"Exception in component tMSSqlInput_5
java.sql.SQLException: The executeQuery method must return a result set.
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:488)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
(...)"
However if I run my query with Microsoft Sql Server Management Studio I get my results so, i don't know what to do...
If someone can help me i'll be great!!
Thanks!!

Re: The executeQuery method must return a result set

alevy — Wed, 17 Aug 2011 00:26:06 GMT

It seems that the SQL statement in tMSSqlInput_5 is an action (e.g. UPDATE, DELETE, INSERT) and not a SELECT query. To perform direct actions statements you should use tMSSqlRow.

Re: The executeQuery method must return a result set

Anonymous — Mon, 16 Feb 2015 07:06:21 GMT

Thanks alevy for your help...it's perfect answer.
Regards--->D