topic Re: Null pointer exception while using Fixed width file. in Talend Studio

Null pointer exception while using Fixed width file.

Sudhee_Maximus — Thu, 14 Nov 2019 12:45:34 GMT

Hello there ,

I am facing this issue with one of the Fixed width file while loading to target MY SQL where it gives null pointer exception.

even though I am handling it by using multiple ways not able to find the issue... can someone help me in this ?

I tried using .... StringHandling.LEN(row.P_LANG_CD1)==0 ? "anpdifddjl****" : row.P_LANG_CD1

(
row2.P_LANG_CD1.equals(null) &&
row2.P_LANG_CD2.equals(null) &&
row2.P_LANG_CD3.equals(null) &&
row2.P_LANG_CD4.equals(null) &&
row2.P_LANG_CD5.equals(null) &&
row2.P_LANG_CD6.equals(null) &&
row2.P_LANG_CD7.equals(null)
)
? null :
(
(Lang1.value.equals(null) && (row2.P_LANG_CD1 != null || row2.P_LANG_CD1 != "")) ||
(Lang2.value.equals(null) && (row2.P_LANG_CD2 != null || row2.P_LANG_CD2 != "")) ||
(Lang3.value.equals(null) && (row2.P_LANG_CD3 != null || row2.P_LANG_CD3 != "")) ||
(Lang4.value.equals(null) && (row2.P_LANG_CD4 != null || row2.P_LANG_CD4 != "")) ||
(Lang5.value.equals(null) && (row2.P_LANG_CD5 != null || row2.P_LANG_CD5 != "")) ||
(Lang6.value.equals(null) && (row2.P_LANG_CD6 != null || row2.P_LANG_CD6 != "")) ||
(Lang7.value.equals(null) && (row2.P_LANG_CD7 != null || row2.P_LANG_CD7 != ""))
) ? "Language code not found": null

To Identify the value which is troubling me I tried different ways as shown above and attacehd , but the value shows empty instead ... not sure how to resolve this issue.

Re: Null pointer exception while using Fixed width file.

Sudhee_Maximus — Thu, 14 Nov 2019 14:13:42 GMT

looks like i got a solution ... Thanks

Re: Null pointer exception while using Fixed width file.

Anonymous — Tue, 19 Nov 2019 02:45:18 GMT

Hi,

If you are using any Java function, you need to make sure that the incoming data for that column is not null. If you anticipate that any column may have null value also, you need to add a null check first before doing other operations.

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

Re: Null pointer exception while using Fixed width file.

Sudhee_Maximus — Tue, 19 Nov 2019 08:54:36 GMT

hey nikhil,

thanks for the reply , I sorted out the issue and its working fine now ...

will reach out to you if any help needed 🙂

Re: Null pointer exception while using Fixed width file.

Anonymous — Tue, 19 Nov 2019 14:00:24 GMT

@SudheeReddy

Thanks for the update. Could you please mark the topic as resolved?

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