topic Re: tDBOutput_1 null java.lang.NullPointerException: null in Talend Studio

tDBOutput_1 null java.lang.NullPointerException: null

JayZ1 — Fri, 15 Nov 2024 22:29:41 GMT

I was unsure what was causing a null pointer exception.

I am connecting to 2 databases and running a query and inserting that data into another database. (MSSQL->Oracle) there are NULL values in the data but i thought I would still be able to insert data without any issues, can anyone help me with this?

Also i wasn't sure if i needed to use denormalization, any idea whats causing the issue?

Re: tDBOutput_1 null java.lang.NullPointerException: null

Anonymous — Fri, 07 Oct 2022 11:48:21 GMT

Your tDBConnection_1 and tDBConnection_2 need to be connected to the main the Subjob OR connected to a tPreJob component. Having your tDBConnection_2 unconnected means that the main Subjob can potentially run before the connection has been created.

Re: tDBOutput_1 null java.lang.NullPointerException: null

Anj24 — Mon, 17 Oct 2022 06:35:49 GMT

Also, make sure to close both the DBConnection using the tDBClose component as this also cause NullPointerException in some cases.

Re: tDBOutput_1 null java.lang.NullPointerException: null

VKohler1665560143 — Tue, 18 Oct 2022 05:53:20 GMT

I appreciate the information and advice you have shared.

Employee Connection Insite