topic Re: java.lang.NullPointerException Error in Talend Studio

java.lang.NullPointerException Error

trimech — Sat, 16 Nov 2024 04:55:07 GMT

Hello,

This my first post here and i hope that you can help me (i'm a begginer in TALEND)

I have 4 table :

Vente:ID_VENTE;PRIX_VENTE;DATE_VENTE;PRIX_ACHAT;ID_FOURNISSEUR;ID_VOITURE

Fournisseur; ID_FOURNISSEUR;NOMF;DATE_LIVRAISON

COmpte: ID_COMPTE;NOMC;MAIL;DATE_INSCRIPTION;ID_CLIENT;ID_FOURNISSEUR

Client: ID_CLIENT;NOM;VILLE.

the question which i like to reply is : Give the list of all customers who registered before the 2015-07-11 date and who bought car online and the list of all customers who bought car Not online after 1999-01-20 and the price is smaller then 2000 euro.

I used a TMAP to use my conditions.

and the expression conditons that i use are :

First table

row2.DATE_INSCRIPTION.before(TalendDate.parseDate("dd-MM-yyyy","11-07-2015")) && row2.MAIL != null

Second table :

row2.MAIL==null && row4.DATE_VENTE.after(TalendDate.parseDate("dd-MM-yyyy","20-01-1999"))

and when i make it run, i get this error :

I didn't understant what he trying to tell me.

Please help.

Best regards ,

Trimech

Re: java.lang.NullPointerException Error

JR1 — Tue, 20 Aug 2019 08:42:07 GMT

It tries to tell you that you want to read from a property which has not been initialised yet. Possibly the date columns are null in some cases and you try to run a method (e.g. after) on such a column. I would first try the following.

Change your filter expressions as follows:

First table

row2.DATE_INSCRIPTION != null && row2.MAIL != null && row2.DATE_INSCRIPTION.before(TalendDate.parseDate("dd-MM-yyyy","11-07-2015"))

Second table :

row4.DATE_VENTE != null && row2.MAIL==null && row4.DATE_VENTE.after(TalendDate.parseDate("dd-MM-yyyy","20-01-1999"))

Let us know if this helps.

Re: java.lang.NullPointerException Error

trimech — Tue, 20 Aug 2019 19:04:47 GMT

Thanks a lot JR.

It works but in the result i get so many time the same result like in the picture.

I think there is somthing wrong in my Tmap. Can you see it ?

Thanks,

Trimech

Re: java.lang.NullPointerException Error

JR1 — Tue, 20 Aug 2019 19:12:22 GMT

It may be that the Match Model is set up incorrectly in your lookups. Can you please provide a screenshot of your tMap where the lookup settings are expanded (the lollipops with the "1" in red on top of the lookups row2 and row4)? This should be set to "Unique Match" or "First Match".

Re: java.lang.NullPointerException Error

trimech — Tue, 20 Aug 2019 19:27:07 GMT

here are the catches.

Thanks

Re: java.lang.NullPointerException Error

JR1 — Tue, 20 Aug 2019 20:00:13 GMT

Hm. This actually looks OK. Are you sure that your input does not contain e.g. six records with ID_CLIENT = 1 and six with ID_CLIENT = 7? If this were the case, then I would expect this output. You could always aggregate the input or the output over all columns by using a tAggregate component before or after tMap, if you are after distinct records.