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 ?
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
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,
