java.lang.NullPointerException using mysql

One Star

java.lang.NullPointerException using mysql

I get the following error code when I run my job. I am using Windows 7 with TOS 4.0.3.r47759.
I think it might be schema problem but I'm not sure where it is. Any ideas?
Here is a screenshot of my job > http://dl.dropbox.com/u/774969/talend_error_2.png
Thanks.
Starting job trefis_mysql_to_sfdc_sandbox_contact at 13:26 28/02/2011.
Exception in component tMap_1
java.lang.NullPointerException
at trefis.trefis_mysql_to_sfdc_sandbox_contact_0_4.trefis_mysql_to_sfdc_sandbox_contact.tMysqlInput_1Process(trefis_mysql_to_sfdc_sandbox_contact.java:4114)
at trefis.trefis_mysql_to_sfdc_sandbox_contact_0_4.trefis_mysql_to_sfdc_sandbox_contact.runJobInTOS(trefis_mysql_to_sfdc_sandbox_contact.java:13239)
at trefis.trefis_mysql_to_sfdc_sandbox_contact_0_4.trefis_mysql_to_sfdc_sandbox_contact.main(trefis_mysql_to_sfdc_sandbox_contact.java:13048)
Job trefis_mysql_to_sfdc_sandbox_contact ended at 13:26 28/02/2011.
Community Manager

Re: java.lang.NullPointerException using mysql

Hi
I can't see the screenshot of job, please upload it directly to our forum.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: java.lang.NullPointerException using mysql

I've attached the screenshot. Thanks.
Community Manager

Re: java.lang.NullPointerException using mysql

Hi
The error occurs on tMap, it seems there are some null value in some of fields, if this is the case, you need to handle the null value like this:
row1.name==null?"":row1.name
Let us know if you have any questions!
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business