parsing and nullpointer exception error while loading CSV file into MySQL database table

[Anonymous]

Hello everyone,

I'm trying to load multiple csv files into MySQL database( for now trying to load one single csv file ). For this, I'm using four components :

tDBConnection--> tFileInputdelimited-->tConvertType-->tMap-->tDBoutput(MySQL)

NOTE: I'm using tConvertType for retreving empty values as null values.

So, when I run the job...I face the below error: 

Starting job load_job_source_db at 17:19 19/07/2019.

[statistics] connecting to socket on port 3618
[statistics] connected
Couldn't parse value for column 'Agglomerates' in 'row1', value is 'Carla Polson'. Details: java.lang.NumberFormatException: For input string: "Carla Polson"
Couldn't parse value for column 'Agglomerates' in 'row1', value is 'Carla Polson'. Details: java.lang.NumberFormatException: For input string: "Carla Polson"
Couldn't parse value for column 'Agglomerates' in 'row1', value is 'Dan'. Details: java.lang.NumberFormatException: For input string: "Dan"

Exception in component tMap_1 (load_job_source_db)
java.lang.NullPointerException
at java.text.SimpleDateFormat.parse(Unknown Source)
at java.text.DateFormat.parse(Unknown Source)
at routines.TalendDate.parseDate(TalendDate.java:928)
at routines.TalendDate.parseDate(TalendDate.java:886)
at testproject1.load_job_source_db_0_1.load_job_source_db.tFileInputDelimited_1Process(load_job_source_db.java:3530)
at testproject1.load_job_source_db_0_1.load_job_source_db.tDBConnection_1Process(load_job_source_db.java:453)
at testproject1.load_job_source_db_0_1.load_job_source_db.runJobInTOS(load_job_source_db.java:4295)
at testproject1.load_job_source_db_0_1.load_job_source_db.main(load_job_source_db.java:4145)
[statistics] disconnected

Job load_job_source_db ended at 17:19 19/07/2019. [exit code=1]

I'm attaching screenshots: 

1) my design worksapce

2) tFileImputdelimited component properties

3)tmap mappings

4)tDBOutput component properties

Please help me with this, also let me know if you guys need anything else.

Thanks & regards,

Praneeth Reddy

[vapukov]

Hi,

you have an error:

Details: java.lang.NumberFormatException: For input string: "Carla Polson"

which is means - you have a text data in the numeric column

first, what you need to do - compare real file schema and schema defined in the tFileInputDelimited 

regards