Automate inserting data into mysql

[Kenny Nguyen]

Hi All,

I wrote a jsp to insert csv files into mysql but the only problem is that i have to initiate the job everytime i want to do it. Also the csv file names are dynamic as well so I can't hard code it. I am wondering if anyone has automated csv file import into mysql.

I'm looking for some direction on a program that monitors a directory for new csv files that are coming in and the automatically insert in sql.

Any assistance would be appreciated.

Ken