Talend community forum / java.lang.NullPointerException when setting a 'null' value

NicolasTT · 2012-04-19 11:29:15

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:

Code:

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,

Uploaded Images

Last edited by NicolasTT (2012-04-19 11:38:35)

pedro · 2012-04-19 11:41:32

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

NicolasTT · 2012-04-19 11:48:59

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

In the java code :

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;

pedro · 2012-04-19 12:09:48

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.

Code:

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

Regards,
Pedro

NicolasTT · 2012-04-19 13:29:14

Thanks,

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

NicolasTT · 2012-04-19 14:20:59

Code:

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

works and

Code:

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?

Announcement

Unanswered posts

#1 2012-04-19 11:29:15

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

Code:

#2 2012-04-19 11:41:32

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

#3 2012-04-19 11:48:59

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

Code:

#4 2012-04-19 12:09:48

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

Code:

#5 2012-04-19 13:29:14

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

#6 2012-04-19 14:20:59

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

Code:

Code:

Board footer