topic Re: java.lang.NullPointerException using mysql in Talend Studio

java.lang.NullPointerException using mysql

Anonymous — Sat, 16 Nov 2024 13:04:02 GMT

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.

Re: java.lang.NullPointerException using mysql

Anonymous — Tue, 01 Mar 2011 06:31:18 GMT

Hi
I can't see the screenshot of job, please upload it directly to our forum.
Best regards
Shong

Re: java.lang.NullPointerException using mysql

Anonymous — Tue, 01 Mar 2011 18:33:08 GMT

I've attached the screenshot. Thanks.

Re: java.lang.NullPointerException using mysql

Anonymous — Wed, 02 Mar 2011 09:05:06 GMT

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