topic Re: getting NULL pointer exception error in tmap in Talend Studio

getting NULL pointer exception error in tmap

sushantk19 — Sat, 16 Nov 2024 02:13:23 GMT

Hi,

I have flags logic as below:

(row6.paymentstate_id.equals(1)||row6.paymentstate_id.equals(6))&& row7.SKU.startsWith("DE-TB")?"Y":"N"
(row6.paymentstate_id.equals(1)||row6.paymentstate_id.equals(6))&& row7.SKU.startsWith("DE-PS")?"Y":"N"
(row6.paymentstate_id.equals(1)||row6.paymentstate_id.equals(6))&& row7.SKU.startsWith("DE-LB")?"Y":"N"

(row6.paymentstate_id.equals(1)||row6.paymentstate_id.equals(6))&&(row5.ordernumber!=null)?"Y":"N"

but because of these conditions i keep getting error

Exception in component tMap_1 (job_DM_000_Order)
java.lang.NullPointerException.

can you suggest why this is happenign and how do i handle this?

Re: getting NULL pointer exception error in tmap

akumar2301 — Fri, 05 Jun 2020 18:11:09 GMT

Hello

You need to handle null values or reverse your condition

“1”.equals(row...) || ....

General rule is to check null value before using it in any java expression

Re: getting NULL pointer exception error in tmap

Anonymous — Sat, 06 Jun 2020 15:07:50 GMT

Hello Sushant,

You have to handle null value when you are executing the job. Since equals, startwith are in built routine and whenever null value comes theses are not able to compare and throughs null pointer exception.
Try this it will work
(row6.paymentstate_id.equals("") || RELATIONAL.ISNULL(row6.paymentstate_id)) && (row7.SKU.equals("") || RELATIONAL.ISNULL(row7.SKU)) ? "" : (row6.paymentstate_id.equals(1)||row6.paymentstate_id.equals(6))&& row7.SKU.startsWith("DE-TB")?"Y":"N"

Thanks

Re: getting NULL pointer exception error in tmap

sushantk19 — Mon, 08 Jun 2020 07:12:17 GMT

yes, that worked now. Actually I didnt handle NULL values first.