Ok, first thanks for your solution.

Code_acte and code are numeric, that's why I use ==

How could I know if my output fileds allows null value ? (=>Except for the primary key, they are all nullable)

Even if i transform Code_acte and code in string, I still have my compilation problem, and it doesn't tell me more than "Exception in thread main java.lang.error: compilation pb non resolved"

I rly don't see where is the mistake, I'm actually testing several expressions to check what I can do/cannot do, but if sbdy knows more, it will help !

Thanks for your help

After a new serie of test, i can tell you that the test button in the TMap component doesn't work correctly, when I execute the job it works (just with compareDate) and when I test the expression in the Tmap it still tells me "Exception in thread..."

So the test button doesn't work -_-

I don't think it's ever worked properly.

Is you NPE pointing to this expression, or is the problem that the output field does not allow nulls?

You could check all input params for null first.

(null != row1.Code_acte && null != row2.DateActe && null != row1.Datedebut) ?(row1.Code_acte.equals(row2.Code)?TalendDate.compareDate(row2.DateActe,row1.Datedebut,"dd-MM-yyyy"):null):null

Hi

I can't fix this damn NPE, all my fields allow null, but then it still doesn't work.

The problem is due to an exeption in component tAccessOutput_1, but I see nothing wrong in it.

So what does mean this error message, something wrong with my Tmap component or with my tAccessOutput ?

Thanks for your help !

Sorry but how can i know the line that generate the NPE, my message error is this one :

Exception in component tAccessOutput_1
java.lang.NullPointerException
    at projetlocal.testcodeacte2_0_1.TestCodeActe2.tAccessInput_1Process(TestCodeActe2.java:1240)
....

Can't find my mistake, action on table weither it's create nor drop if it exist and create doesn't change anything. Id I edit the schem and change the type of my data, the error message changes, it becomes and ODBC exception.

Thanks for your help !

And where can I find this code ?

At the bottom left of the workspace window (where you create the jobs), but above the Context/Code/Run/etc tabs, there is a small tab labeled "code".