Null Pointer Exception using tELTOracleOutput

Highlighted
Five Stars

Null Pointer Exception using tELTOracleOutput

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


Accepted Solutions
Eight Stars

Re: Null Pointer Exception using tELTOracleOutput

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.

View solution in original post


All Replies
Eight Stars

Re: Null Pointer Exception using tELTOracleOutput

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 .

2019-04-29_8-54-39.png

 

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.

 

Five Stars

Re: Null Pointer Exception using tELTOracleOutput

Hi,

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

Thanks,

Neil
Eight Stars

Re: Null Pointer Exception using tELTOracleOutput

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.

View solution in original post

Five Stars

Re: Null Pointer Exception using tELTOracleOutput

That was it.

Thanks very much for your help

Neil

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now