topic Re: Null pointer exception in tDBOutputBulkExec while loading data from CSV to ORACLE in Talend Studio

Null pointer exception in tDBOutputBulkExec while loading data from CSV to ORACLE

YK3 — Fri, 15 Nov 2024 21:52:39 GMT

I am getting below error message while running a simple job

"Exception in component tDBOutputBulkExec_1_tOBE (test1_new)

java.lang.NullPointerException"

I am just trying to load 1 record from CSV to ORACLE Table via

tDBOutputBulkExec_1 component .I have Just 3 columns in my Oracle table and all are nullable.Control File and data files are getting created correctly in the folder but its still giving the error.

Re: Null pointer exception in tDBOutputBulkExec while loading data from CSV to ORACLE

Anonymous — Sun, 23 Apr 2023 00:48:54 GMT

Hello @Yogender Kumar ,

Could you please check the button 'Trailing null columns' in tDBOutputBulkExec's advanced settings page as the below?

if it doesn't help, please provide the while job execution error log for more investigation.

Re: Null pointer exception in tDBOutputBulkExec while loading data from CSV to ORACLE

Anonymous — Mon, 24 Apr 2023 04:48:51 GMT

Hello @Yogender Kumar

Here is a related topic about NullPointerException in component tDBOutputBulkExec(oracle)

https://community.talend.com/s/feed/0D53p00008TJPZGCA5

Feel free to let us know if it helps for your use case.

Best regards

Sabrina