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

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog