Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Also, make sure to close both the DBConnection using the tDBClose component as this also cause NullPointerException in some cases.