Null Pointer Exception using tELTOracleOutput

[Anonymous]

Hi,

I am getting a null pointer exception when trying to use the tELTOracle... components in Talend Studio 7.0.1 connecting to an Oracle 12c Release 1 database.

Looking at the code, I am fairly sure the update statement is being generated correctly, but on running i get the following error :

java.lang.NullPointerException
at reviews.eltchi_0_1.eltCHI.tELTOracleMap_1Process(eltCHI.java:700)
at reviews.eltchi_0_1.eltCHI.runJobInTOS(eltCHI.java:3098)
at reviews.eltchi_0_1.eltCHI.main(eltCHI.java:2926)

I have attached a document with the job structure and map component

Any ideas?

Thanks in advance for your help

Neil

[Anonymous]

Some thoughts,

Does your tELTOracleMap have a connection to the database? Its kind of hard to find as you cannot double click on the map component itself to register it a db connection, but single click the component, then click component button near the palate .

Additionally, to check if the syntax of your query is correct, copy and paste "Generated SQL Select query" from the ELTMap into the Oracle IDE of your choice.

[Anonymous]

Hi,

Thanks for the response. Yes the map does have a connection, and the select query is valid

Thanks,

Neil

[Anonymous · Accepted solution]

Interesting. 

Looking at your screenshot, it's possible the query is trying to execute before the database connection is established.  Can you connect your first subjob with the db cxn via an OnSubjobOK to the map component.  That way you enforce subjob execution order.

[Anonymous]

That was it.

Thanks very much for your help

Neil