topic Null Pointer Exception using tELTOracleOutput in Talend Studio

Null Pointer Exception using tELTOracleOutput

Anonymous — Sat, 16 Nov 2024 05:58:40 GMT

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

Re: Null Pointer Exception using tELTOracleOutput

Anonymous — Mon, 29 Apr 2019 13:59:08 GMT

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.

Re: Null Pointer Exception using tELTOracleOutput

Anonymous — Mon, 29 Apr 2019 14:07:47 GMT

Hi,

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

Thanks,

Neil

Re: Null Pointer Exception using tELTOracleOutput

Anonymous — Mon, 29 Apr 2019 14:10:29 GMT

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.

Re: Null Pointer Exception using tELTOracleOutput

Anonymous — Mon, 29 Apr 2019 14:16:41 GMT

That was it.

Thanks very much for your help

Neil