One Star

Talend New Job Error

Hi,
When execute a new job, i have got the below error message.
Please find the attached screen shot.
So Please let me know, In which situation the below mentioned error appear.
"Starting job bpcateg at 16:57 14/08/2013.

connecting to socket on port 3718
connected
Exception in component tMSSqlInput_1
java.sql.SQLException: Incorrect syntax near the keyword 'VALUES'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1304)
at migaration.bpcateg_0_1.bpcateg.tMSSqlInput_1Process(bpcateg.java:3595)
at migaration.bpcateg_0_1.bpcateg.runJobInTOS(bpcateg.java:7446)
at migaration.bpcateg_0_1.bpcateg.main(bpcateg.java:7312)
disconnected
Job bpcateg ended at 16:57 14/08/2013. "
Thanks
Siva
5 REPLIES
Five Stars

Re: Talend New Job Error

the sql seems incorrect in the input component can you show me the query of that component
One Star

Re: Talend New Job Error

Hi,
Please find the attached screen shot of the SQL query.
Thanks
Siva
Seventeen Stars

Re: Talend New Job Error

It looks like the identifier VALUES matchs with a reserved word.
Put that identifier into double quotas ARCOS."VALUES" should work.
One Star

Re: Talend New Job Error

hi
i am getting error as incorrect syntax near the keyword 'order' but not showing any error symbol on any components.For information order is my target table.
can anyone help me out to resolve this issue.
Seven Stars

Re: Talend New Job Error

"order" is a SQL key word so, if that is your table name, you need to delimit it with double-quotes. Since double-quotes have a specific meaning for Java (being to delimit a string), you will also need to escape the double-quotes with a back-slash.
In the tOutput component, make the table name: "\"order\""