topic Re: tOracleOutput missing keyword "VALUES" in Talend Studio

tOracleOutput missing keyword "VALUES"

_AnonymousUser — Mon, 18 Jun 2012 08:33:13 GMT

Hi all,
I'm using TOS 5.0.1.r74687-64bit on windows 7 64bit.
I'm trying to upload data into my Oracle DB using tOracleOutput. I get the Oracle error:
ORA-00926: missing VALUES keyword
Although the java source code contains the keyword, I still get the error. Does anyone know a solution to this?
String insert_tOracleOutput_2 = "INSERT INTO " + tableName_tOracleOutput_2 + " (column1, column2) VALUES (?,?)";

Regards,
Benjamin

Re: tOracleOutput missing keyword "VALUES"

Anonymous — Mon, 18 Jun 2012 08:40:19 GMT

Hi Benjamin
Please use tJava to print ((String)globalMap.get("tOracleOutput_1_QUERY")) by using "OnsubjobError" on tOracleOutput. The query may be not correct.
Do not select "Die on error" option on tOracleOutput.
Regards,
Pedro

Re: tOracleOutput missing keyword "VALUES"

_AnonymousUser — Mon, 18 Jun 2012 08:56:50 GMT

No message is printed:
Starting job oracleTest at 09:55 18/06/2012.
connecting to socket on port 3460
connected
ORA-00926: missing values keyword
disconnected
Job oracleTest ended at 09:55 18/06/2012.

Re: tOracleOutput missing keyword "VALUES"

Anonymous — Mon, 18 Jun 2012 08:59:56 GMT

Hi
Could you send me an email and attach this job?
I will test it for you.
Regards,
Pedro

Re: tOracleOutput missing keyword "VALUES"

_AnonymousUser — Mon, 18 Jun 2012 09:07:34 GMT

done,
thank you!

Re: tOracleOutput missing keyword "VALUES"

Anonymous — Mon, 18 Jun 2012 09:19:36 GMT

Hi Benjamin
It seems you didn't export this job correctly. I get an invalid zip file.
Step1: Right click on this job.
Step2: Select "Export Items".
Step3: Browser the name of this zip file and click on "Finish".
Regards,
Pedro

Re: tOracleOutput missing keyword "VALUES"

_AnonymousUser — Mon, 18 Jun 2012 09:26:44 GMT

Okay,
i send you the exported items.
Regards

Re: tOracleOutput missing keyword "VALUES"

Anonymous — Mon, 18 Jun 2012 09:30:07 GMT

Hi
I notice that what you typed in "Table" text field is "I2B2IDRT.IDRTHelper".
Please change it into "IDRTHelper".
Regards,
Pedro

Re: tOracleOutput missing keyword "VALUES"

_AnonymousUser — Mon, 18 Jun 2012 09:35:34 GMT

Thank you, that helped. Stupid mistake.
Regards,
Benjamin