topic Re: Error on tJavaRow in Talend Studio

Error on tJavaRow

Anonymous — Sat, 16 Nov 2024 14:27:39 GMT

Hi,
I've to do a migration beween SqlServer 7.0 and PostgreSQL 8.2. I don't know how, but I've null value on my Primary key in SqlServer that I try to filter... but i've the following error :
Starting job MigreSite at 10:57 13/02/2008.
Exception in component tJavaRow_1
java.lang.NullPointerException
at gespat.migresite.MigreSite.tMSSqlInput_2Process(MigreSite.java:1882)
at gespat.migresite.MigreSite.runJobInTOS(MigreSite.java:2350)
at gespat.migresite.MigreSite.main(MigreSite.java:2269)
Job MigreSite ended at 10:57 13/02/2008.
Another question : can i do in the SELECT (input) WHERE <column_name> IS NOT NULL ... and other conditions ?

Re: Error on tJavaRow

Anonymous — Wed, 13 Feb 2008 10:16:35 GMT

The generated code :
// ============================================================================
//
// Copyright (c) 2005-2007, Talend Inc.
//
// This source code has been automatically generated by Talend Open Studio
// / JobDesigner (CodeGenerator version 2.3.0.r8623).
// You can find more information about Talend products at www.talend.com.
// You may distribute this code under the terms of the GNU LGPL license
// ( http://www.gnu.org/licenses/lgpl.html).
//
// ============================================================================
package gespat.migresite;
import routines.DataOperation;
import routines.Mathematical;
import routines.Numeric;
import routines.Relational;
import routines.StringHandling; import routines.TalendDataGenerator; import routines.Ta

To see the whole post, download it here
OriginalPost.pdf

Re: Error on tJavaRow

Anonymous — Wed, 13 Feb 2008 14:10:45 GMT

Now it's ok ! I've just use a tMap with filter in the tMap. I use (<colonne>==null || <colonne>==0)?null:<colonne> to do what i want !

Re: Error on tJavaRow

Anonymous — Wed, 13 Feb 2008 14:42:35 GMT

Great,
I'm still figuring out how the Null pointer had happend.
I think that the problem comes from the tMap : tJavaRow doesn't automatically propage datas so for each of your column, you have to specify manually : output_row.mycolumn = input_row.mycolumn else it will be null after.
There might be a bug because it prints "Exception in tJavaRow" which looks fairly incorrect according to my explanations....
Regards,

Re: Error on tJavaRow

Anonymous — Wed, 13 Feb 2008 14:45:59 GMT

Thanks for this explication !
It should help me if i use it after !
Regards,

Re: Error on tJavaRow

Anonymous — Wed, 06 May 2009 20:02:06 GMT

It is a nice post. I got it very useful. Thanks!
simulation emprunt immobilier

Re: Error on tJavaRow

Anonymous — Sat, 09 May 2009 14:18:27 GMT

Wow ! The code is very very long. I assume that you are very good in computer programming. It is a good talent. Good Job !

Simulation pret immobilier