https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266045#M45393 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="job.JPG" style="width: 567px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1YR.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153359iD87F09F81FD1C76D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1YR.jpg" alt="0683p000009M1YR.jpg" /></span></SPAN></P> <P><A href="https://paste.ofcode.org/J49fHjLtFkBZbHzswkW9J6" target="_blank" rel="nofollow noopener noreferrer">https://paste.ofcode.org/J49fHjLtFkBZbHzswkW9J6</A></P> <P>&nbsp;</P> <P>Shared job flow &amp; query</P> Thu, 22 Nov 2018 11:37:50 GMT MahiwalVinit 2018-11-22T11:37:50Z https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266043#M45391 <P>I have connected Talend with MSSQL&nbsp;using JDBC&nbsp;connection.&nbsp;</P><P>I am able to execute simple SQL however&nbsp;for complex sql I am getting an error message</P><P><STRONG>The executeQuery method must return a result set</STRONG></P><P>How It can be resolved.&nbsp;</P> Sat, 16 Nov 2024 07:14:11 GMT https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266043#M45391 MahiwalVinit 2024-11-16T07:14:11Z https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266044#M45392 <P>Hi,</P><P>&nbsp;</P><P>&nbsp; &nbsp; Could you please share the query along with screenshots of the job flow and the component design for detailed analysis?</P><P>&nbsp;</P><P>Warm Regards,</P><P>&nbsp;</P><P>Nikhil Thampi</P> Wed, 21 Nov 2018 19:01:29 GMT https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266044#M45392 Anonymous 2018-11-21T19:01:29Z https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266045#M45393 <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="job.JPG" style="width: 567px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M1YR.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/153359iD87F09F81FD1C76D/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M1YR.jpg" alt="0683p000009M1YR.jpg" /></span></SPAN></P> <P><A href="https://paste.ofcode.org/J49fHjLtFkBZbHzswkW9J6" target="_blank" rel="nofollow noopener noreferrer">https://paste.ofcode.org/J49fHjLtFkBZbHzswkW9J6</A></P> <P>&nbsp;</P> <P>Shared job flow &amp; query</P> Thu, 22 Nov 2018 11:37:50 GMT https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266045#M45393 MahiwalVinit 2018-11-22T11:37:50Z https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266046#M45394 <P><A href="https://community.qlik.com/s/profile/0053p000007LLsoAAG">@vmahiwal</A></P> <P>&nbsp;</P> <P>Talend do not show any deviation in the processing style whether the underlying SQL is easy or complex. Did you run the above query from SQL assistant and checked the validity of the same?</P> <P>&nbsp;</P> <P>Warm Regards,</P> <P>&nbsp;</P> <P>Nikhil Thampi</P> Mon, 26 Nov 2018 05:36:56 GMT https://community.qlik.com/t5/Talend-Studio/Error-executeQuery-method-must-return-a-result-set/m-p/2266046#M45394 Anonymous 2018-11-26T05:36:56Z