Mar 8th, 2011, 11:20 PM
Best approach for loading the CSV file into the database
I need to load a CSV into a database once a week. There is some data massaging required as the CSV file has data for 2 tables. So I will have to process the CSV file a bit, probably convert it into 2 different CSV files and load it into a database.
I already have quartz configured in place. Do you think it would be an overkill to use spring batch to do the job? I am wondering when should I use it and when should I just do away with quartz bean do the processing itself.