topic Re: tJavaRow : null pointer exception with length() method in Talend Studio

tJavaRow : null pointer exception with length() method

YVES1 — Sat, 16 Nov 2024 12:50:23 GMT

Hi ,
I built the job tFileInputExcel ------> tJavaRow ----> tLogRow
I am testing length of the column in the tJavaRow component with String chaine = input_row.Column1 then lg = chaine.length() but this latter is generating a null pointer exception.
Here enclosed 3 screenshots (job , tJavaRow code and null pointer exception error)

With best regards,
Yves.

Re: tJavaRow : null pointer exception with length() method

bdurand — Wed, 29 Jun 2011 16:35:17 GMT

Maybe input_row.Column1 is null.
You can try : if (chaine!=null) { lg = chaine.length(); }
regards,

Re: tJavaRow : null pointer exception with length() method

YVES1 — Wed, 29 Jun 2011 21:27:19 GMT

Hi ,
I did this test as well but it fails as well.
A s soon as I manage input_row.Column1 with length() method or != null the result is null pointer exception.
Best regards,
Yves.

Re: tJavaRow : null pointer exception with length() method

Anonymous — Thu, 30 Jun 2011 05:41:42 GMT

Hi
try if (!Relational.ISNULL(input_row.Column1)){
}

Re: tJavaRow : null pointer exception with length() method

Anonymous — Thu, 30 Jun 2011 08:15:17 GMT

This will prevent even if that column have blank space.
if(input_row.Column1!=null && input_row.Column1.trim().length()>0){
String a = input_row.Column1.length();
}

Re: tJavaRow : null pointer exception with length() method

YVES1 — Tue, 05 Jul 2011 08:54:56 GMT

Hi ,
I experienced the following if (!Relational.ISNULL(input_row.Column1)) suggested by lijolawrance and it works fine.
Thank you veru much.
Best regards,
Yves.

Re: tJavaRow : null pointer exception with length() method

Anonymous — Tue, 05 Jul 2011 08:56:09 GMT

Hi Yves
Glad to hear that, thanks for your feedback!
Best regards
Shong