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

Anonymous — Sat, 16 Nov 2024 05:13:16 GMT

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

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

vapukov — Tue, 23 Jul 2019 07:44:19 GMT

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

topic parsing and nullpointer exception error while loading CSV file into MySQL database table in Data Quality

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

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