topic Re: why am I getting conn_tDBOutput is null error in Talend Studio

why am I getting conn_tDBOutput is null error

Just_learner — Fri, 15 Nov 2024 21:13:54 GMT

I made a job where I took data from source and dumped into destination. To make my job dynamic I created two db connection metadata and added there connection in tdboutput.

dev destination database is the db connection metadata where I've mentioned all the credentials of the db and xyz is the table name.

Now I created an another job where I dragged my job and tried to run it. While running it gave an error that

java.lang.NullPointerException: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "conn_tDBOutput_2" is null

To solve this when I manually wrote all credential of my db in

tDBOutput_2 instead of using dev destination database db connection it worked fine without showing any error.

Is this any bug where job is not able to use db connection or am I making some mistake?

Re: why am I getting conn_tDBOutput is null error

Anonymous — Sat, 25 Nov 2023 08:56:31 GMT

Make sure the DB connection is created before it is used, we usually use tPreJob to perform some initialization operations such as creating DB connection in the beginning of job. eg:

tPreJob--oncomponentok--tDBConnection

....main-->tDBOutput

Regards

Shong

Re: why am I getting conn_tDBOutput is null error

Just_learner — Mon, 04 Dec 2023 05:36:04 GMT

Thank you @Shicong Hong. It worked.

Re: why am I getting conn_tDBOutput is null error

Anonymous — Mon, 04 Dec 2023 07:41:07 GMT

Great, thanks for your feedback!