java.lang.NullPointerException using mysql

Highlighted
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.
Highlighted
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
Highlighted
One Star

Re: java.lang.NullPointerException using mysql

I've attached the screenshot. Thanks.
Highlighted
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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog