topic Re: tOracleRow error in Talend Studio

tOracleRow error

Anonymous — Mon, 22 Aug 2016 14:22:28 GMT

tOracleRow java.lang.NullPointerException
I am facing the above exception when I am trying to execute the following job:
tFileInputJSON----tFlowToIterate-----tOracleRow
with the sql query---->"update employee_combine set email_new = "+((String)globalMap.get("email"))+" where id<=50"
I am retrieving the email from JSON file and inserting into an existing oracle table.
I understand that null values are being passed, and hence the database is giving the exception.
Can anyone suggest what changes I could make so that the flow works.

Re: tOracleRow error

Anonymous — Tue, 23 Aug 2016 02:49:59 GMT

Hi
Assuming the job design looks like
tFileInputJSON--row1(main)--tFlowToIterate---iterate--tOracleRow

The correct syntax should be:

"update employee_combine set email_new = "+((String)globalMap.get("row1.email"))+" where id<=50"

Regards
Shong

Re: tOracleRow error

Anonymous — Tue, 23 Aug 2016 14:44:42 GMT

It is still throwing the same exception!

Re: tOracleRow error

Anonymous — Thu, 25 Aug 2016 10:24:55 GMT

Hi
Can you upload a screenshot of your job and show us the query used on tOracleRow?

Regards
Shong