Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have connected Talend with MSSQL using JDBC connection.
I am able to execute simple SQL however for complex sql I am getting an error message
The executeQuery method must return a result set
How It can be resolved.
Hi,
Could you please share the query along with screenshots of the job flow and the component design for detailed analysis?
Warm Regards,
Nikhil Thampi
https://paste.ofcode.org/J49fHjLtFkBZbHzswkW9J6
Shared job flow & query
@vmahiwal
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?
