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