Talend community forum / tOracleOutput missing keyword "VALUES"

Benjamin_ · 2012-06-18 09:33:13

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

pedro · 2012-06-18 09:40:19

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

Benjamin_ · 2012-06-18 09:56:50

No message is printed:

Starting job oracleTest at 09:55 18/06/2012.
[statistics] connecting to socket on port 3460
[statistics] connected
ORA-00926: missing values keyword
[statistics] disconnected
Job oracleTest ended at 09:55 18/06/2012. [exit code=0]

pedro · 2012-06-18 09:59:56

Hi

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

Regards,
Pedro

Benjamin_ · 2012-06-18 10:07:34

done,

thank you!

pedro · 2012-06-18 10:19:36

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

Benjamin_ · 2012-06-18 10:26:44

Okay,

i send you the exported items.

Regards

pedro · 2012-06-18 10:30:07

Hi

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

Regards,
Pedro

Benjamin_ · 2012-06-18 10:35:34

Thank you, that helped. Stupid mistake.

Regards,
Benjamin

Announcement

Unanswered posts

#1 2012-06-18 09:33:13

tOracleOutput missing keyword "VALUES"

#2 2012-06-18 09:40:19

Re: tOracleOutput missing keyword "VALUES"

#3 2012-06-18 09:56:50

Re: tOracleOutput missing keyword "VALUES"

#4 2012-06-18 09:59:56

Re: tOracleOutput missing keyword "VALUES"

#5 2012-06-18 10:07:34

Re: tOracleOutput missing keyword "VALUES"

#6 2012-06-18 10:19:36

Re: tOracleOutput missing keyword "VALUES"

#7 2012-06-18 10:26:44

Re: tOracleOutput missing keyword "VALUES"

#8 2012-06-18 10:30:07

Re: tOracleOutput missing keyword "VALUES"

#9 2012-06-18 10:35:34

Re: tOracleOutput missing keyword "VALUES"

Board footer