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 retrieving 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 workspace

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

[Anonymous]

Hey Nikhil,

Thanks a Lot! It works!....now I'm trying to load multiple .csv files of the same format to the same MySQL DB I've used previously.

I used tFileList for iteration of all the files. But I receive below error for the tFileList component :

Error in the component's properties:The method add(String) in the type List<String> is not applicable for the arguments ().

I'm attaching screenshots again, please have a look at them and let me know what's the issue.

Thanks and regards,

Praneeth

job_design_4.PNG
tFileInput_prop.PNG
tFileList_prop.PNG

[Anonymous]

Hi Praneeth,

     I would recommend to create it as a separate post so that original query will get sufficient focus. We have resolved your original query and this is a totally different issue. Could you please spare a second to mark the current topic as resolved? It will help other community members during their reference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Okay. I've posted another topic under subject name 'Loading multiple CSV files into MySQL database '. Kindly, please address my issue over there.

Thanks and regards,

Praneeth