topic Re: java.lang.NullPointerException when setting a 'null' value in Talend Studio

java.lang.NullPointerException when setting a 'null' value

NicolasTT — Thu, 19 Apr 2012 10:29:15 GMT

Hello,
I am faced with a 'java.lang.NullPointerException' when I set a null value in a (nullable) field a table of my database.
Here's the scenario:
An external source (my tFixedFlowInput in my example) can have a value and then change the value in base, or have no value, and in this case, I set the previous value to the base.
This works, except in the case I have no value in either the external source, or in the database (null and null). In this case, I have a 'java.lang.NullPointerException' on the line corresponding to the value of the field in the TMap:

temp_nva_out_tmp.isOK = !Relational.ISNULL(IN.isOK) ? 1 : temp_nva_in.isOK;

I do not understand how the assignment of the null can generate
'java.lang.NullPointerException'. If I replace temp_nva_in.isOK by 'null', it works correctly.
Thanks for ideas,

Re: java.lang.NullPointerException when setting a 'null' value

Anonymous — Thu, 19 Apr 2012 10:41:32 GMT

Hi
It's a rule that you can type null in expression. But if expression get null from a variable, it will cause NPE exception.
Regards,
Pedro

Re: java.lang.NullPointerException when setting a 'null' value

NicolasTT — Thu, 19 Apr 2012 10:48:59 GMT

My expression is :
!Relational.ISNULL(in.isOK) ? 1 : temp_nva_in.isOK
is the Tmap.
In the java code :

// # Output table : 'temp_nva_out'
	temp_nva_out_tmp.uid = in.uid;
	temp_nva_out_tmp.isOK = !Relational.ISNULL(in.isOK) ? 1 : temp_nva_in.isOK;
	temp_nva_out = temp_nva_out_tmp;

Re: java.lang.NullPointerException when setting a 'null' value

Anonymous — Thu, 19 Apr 2012 11:09:48 GMT

Hi
It seems that there are null values in temp_nva_in.isOK.
You can put a tJavaRow between the input component and tMap and type code as follow.

if(input_row.isOk==null)
output_row.isOk = 0;

Regards,
Pedro

Re: java.lang.NullPointerException when setting a 'null' value

NicolasTT — Thu, 19 Apr 2012 12:29:14 GMT

Thanks,
But I'd like to keep my 'null' value. I don't want to set '0' if it's 'null'.

Re: java.lang.NullPointerException when setting a 'null' value

NicolasTT — Thu, 19 Apr 2012 13:20:59 GMT

temp_nva_out_tmp.isOK = !Relational.ISNULL(in.isOK) ? new Integer( 1 ) : temp_nva_in.isOK;

works and

temp_nva_out_tmp.isOK = !Relational.ISNULL(in.isOK) ? 1 : temp_nva_in.isOK;

doesn't work.
I don't understand why. Thanks if you could explain me?

Re: java.lang.NullPointerException when setting a 'null' value

Ravivarma_india — Tue, 29 Jun 2021 02:32:47 GMT

Initial stage of talend every one face a Null pointer exception , for TALEND TECH SUPPORT JION https://t.me/talendtechsupport

Re: java.lang.NullPointerException when setting a 'null' value

gjeremy1617088143 — Tue, 29 Jun 2021 07:24:00 GMT

Hi, it's due to ternary autoboxing, in the first one it reads the left part as an Integer (it's a wrapper Object wich accept null value) so it will convert temp_nva_in.isOK to Integer

in the second one you set 1 on the left it will read it as an int and convert it as an int(doesn't support null values it's a primitive type) so it throw null pointer exception if temp_nva_in.isOK is null.

you could also write :

temp_nva_out_tmp.isOK = in.isOK != null? new Integer( 1 ) : temp_nva_in.isOK;

Send me Love and Kudos