topic Re: null pointer exception in Talend Studio

null pointer exception

Anonymous — Wed, 12 Jul 2017 17:22:10 GMT

Hi experts,

I'm facing null pointer exception in Tmap when I'm doing calculation below you can see in screen shot,

and I already checked in database for same calculation but their are no null values in them how to resolve this error

Thanks in advance

Regards

A.Sumanth

Re: null pointer exception

Anonymous — Wed, 12 Jul 2017 17:49:44 GMT

Are you sure it is row18 or row1 the object?

Re: null pointer exception

Anonymous — Wed, 12 Jul 2017 18:03:40 GMT

Ya sure it is row18

Re: null pointer exception

Anonymous — Wed, 12 Jul 2017 18:10:59 GMT

Ya it's row18

Re: null pointer exception

Anonymous — Wed, 12 Jul 2017 22:37:07 GMT

Please provide screenshots of your job and tMap mapping. Not sure what it is.

Re: null pointer exception

Anonymous — Thu, 13 Jul 2017 05:47:04 GMT

Re: null pointer exception

cterenzi — Thu, 13 Jul 2017 14:34:11 GMT

Community all-star, @rhall, wrote a very nice guide on how to identify which rows are causing errors in a tMap:

https://www.rilhia.com/quicktips/quick-tip-how-debug-tmap-errors

If this works for you, throw him some kudos.

Re: null pointer exception

Anonymous — Thu, 13 Jul 2017 23:07:26 GMT

If row18.CUST_TOTAL_QUOTA_BEFORE and row18.CUST_TOTAL_QUOTA_USED_BEFORE are both Java Objects of type Double (i.e. they are set as nullable), and are not Java primitive type double, then you should do the expression as follows

( row18.CUST_TOTAL_QUOTA_BEFORE!=null && row18.CUST_TOTAL_QUOTA_USED_BEFORE!=null ? new Double(row18.CUST_TOTAL_QUOTA_BEFORE.doubleValue() - row18.CUST_TOTAL_QUOTA_USED_BEFORE.doubleValue()) : null)

This is an inline if statement. We are checking first that none of the 2 objects are null. Then if both are not null, we do the double substraction, and return a new Double object since your target column is also of type Double. If one or both of the Double objects are null, then we return null. It is up to you to figure out what to do if one of them is null.

If these values can never be null in the database, then you will simplify the logic by unchecking the nullable attribute on the column to make the type of double Java primitive type. However, if they can be null, then you should program as above, i.e. defensively checking for nulls.

Re: null pointer exception

Anonymous — Mon, 17 Jul 2017 10:37:37 GMT

Thank you so much expert,I was struggling with this problem from past ten days you are the one who gave me correct

solution from my question,By understanding the question properly

I need the expert like you for solutions thank you once again it's working fine

Regards

A.Sumanth