Null pointer exception error

Anonymous — Sat, 16 Nov 2024 05:09:40 GMT

Hi,

tMssqlInput -> tJavaRow -> tDBRow(Delete query)

This is my job flow. There is no data in input table and I have used date in where condition of delete query. I am getting following error:

Exception in component tJavaRow_1 (Emp_Del)
java.lang.NullPointerException
at java.util.Calendar.setTime(Unknown Source)
at routines.system.FastDateParser$DateParser.format(FastDateParser.java:99)
at java.text.DateFormat.format(Unknown Source)
at routines.TalendDate.formatDate(TalendDate.java:135)
at drc_etl_dw.emp_del_0_1.Emp_Del.tDBInput_1Process(Emp_Del.java:1328)
at drc_etl_dw.emp_del_0_1.Emp_Del.runJobInTOS(Emp_Del.java:2014)
at drc_etl_dw.emp_del_0_1.Emp_Del.main(Emp_Del.java:1505)

How to solve the error?

Thanks,

Dhara

Re: Null pointer exception error

Anonymous — Fri, 26 Jul 2019 19:00:46 GMT

Hi Dhara,

The error is in tjavarow which means you are trying to do some date processing using some java functions and when null value is coming, its throwing error.

Could you please add Null condition check in your logic and avoid doing date processing for null values? Then things will work fine. If you are still facing the issue, please share the logic you are using with tJavarow and we can take it from there.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

topic Re: Null pointer exception error in Talend Studio

Null pointer exception error

Re: Null pointer exception error