topic Re: tOracleOutput java.lang.NullPointerException in Talend Studio

tOracleOutput java.lang.NullPointerException

vidya821 — Fri, 16 Jun 2017 15:29:44 GMT

Hi,

i am facing the below issue while loading the table with input file

Exception in component tOracleOutput_1 (import_contract)

java.lang.NullPointerException

at sun_project.import_contract_0_1.import_contract.tFileInputDelimited_1Process(import_contract.java:1489)

at sun_project.import_contract_0_1.import_contract.runJobInTOS(import_contract.java:2937)

at sun_project.import_contract_0_1.import_contract.main(import_contract.java:2703)

Can someone give any pointers to check the issue

Thanks

Re: tOracleOutput java.lang.NullPointerException

cterenzi — Sun, 18 Jun 2017 05:43:39 GMT

This usually indicates that a variable in a setting or expression is null when the job is expecting a value. This can happen for a number of reasons. Examine the settings of the component identified in the exception, and make sure that any variables used are spelled correctly and are properly initialized with values before that component executes.

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Mon, 19 Jun 2017 03:19:46 GMT

Hi,

Did you use tOracleConnection compomnent in your work flow? If so, is there any connector(onsubjobok or oncomponentOk) between tOracleConnection and tOracleOutput component?

Screenshots will be helpful for us to address your issue.

Best regards

Sabrina

Re: tOracleOutput java.lang.NullPointerException

vidya821 — Mon, 19 Jun 2017 10:32:57 GMT

Thanks,

i feel the issue is with the field values having values as null during the insert. because i checked with some fields having values and it worked.

could you please let me know what expression to be used in tMap to avoid this error.

Re: tOracleOutput java.lang.NullPointerException

vidya821 — Mon, 19 Jun 2017 10:39:54 GMT

Hi,

Thanks, but i think issue is with the null value in some of the fields during insert.
Below is the error
Exception in component tOracleOutput_1 (import_product)
java.lang.NullPointerException
at sun_project.import_product_0_1.import_product.tFileInputDelimited_1Process(import_product.java:959)
at sun_project.import_product_0_1.import_product.runJobInTOS(import_product.java:1996)
at sun_project.import_product_0_1.import_product.main(import_product.java:1762)

and code at line 959 is
java.sql.PreparedStatement pstmt_tOracleOutput_1 = conn_tOracleOutput_1
.prepareStatement(insert_tOracleOutput_1);

Re: tOracleOutput java.lang.NullPointerException

cterenzi — Mon, 19 Jun 2017 18:02:31 GMT

@xdshi was on the mark, it appears your connection isn't initialized properly. If you're using a tOracleConnection component to set up the database connection, you need to ensure that component executes first.

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Tue, 20 Jun 2017 08:03:00 GMT

Hi vidya821,

Would you mind posting your job setting screenshots into forum which will be helpful for us to address your issue quickly.

Best regards

Sabrina

Re: tOracleOutput java.lang.NullPointerException

vidya821 — Tue, 20 Jun 2017 10:22:25 GMT

Yes it worked, Thanks so much

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Tue, 20 Jun 2017 10:33:49 GMT

Hi,

Great it works. Feel free to let us know if there is any further help we can give.

Best regards

Sabrina

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Thu, 10 Aug 2017 08:39:27 GMT

Hi,

Hi ,

I am facing an issue while transfering data from mongoDB to oracle. The error message is as follows -

Exception in component tOracleOutput_1
java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

I am getting this error in toracleoutput component.

Could you please where i am doing wrong.

Thanks,

Ravi

Re: tOracleOutput java.lang.NullPointerException

vidya821 — Thu, 10 Aug 2017 09:12:56 GMT

Hi,

My issue was wrt to oracle connection, the tOracleOutput_1 component was not connected to a DB,
however your issue seems to be with the incorrect syntax, the issue might not be with the tOracleOutput component as per the détails you provided.
The exception is caused in the tOracleOutput component due to issues in some other component.
Also check if the data type for some of the data sent from MongoDB to Oracle DB might differ.
share the screenshot if possible to work it out.
Thanks

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Thu, 10 Aug 2017 10:47:42 GMT

Find Snap of component and run tab-

Let me know what is issue here.

Thanks,

Re: tOracleOutput java.lang.NullPointerException

vidya821 — Thu, 10 Aug 2017 11:01:48 GMT

1) tOracleOutput should be connected to a database connection tOracleConnection.
2) use tMap component to map the data between two connections, this way u will be sure that the data types is matched between tables
Thanks

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Fri, 11 Aug 2017 10:18:31 GMT

Thank you vidya. Its really helpful

Regards,

Ravi

Re: tOracleOutput java.lang.NullPointerException

Anonymous — Mon, 05 Feb 2018 06:50:52 GMT

Thanks so much