In my current requirement i have a legacy txt file that contains lots of data , each record per row. The file is checked in at a cvs repository
A legacy system keeps on updating it (adding/deleting) from time to time.
I am writing a code that creates a replica of this legacy txt file in Oracle database.
So i need to write a code in java that creates a sync between my table and the legacy txt file.
My initial thought is to get hold of a cvs api that reads a diff of this legacy file in repository to a local copy and identified which records are added/modified/deleted from the file.
Based on that i will update my database. This will be a time triggered process.
Any thoughts or suggestions? Any standard java api i can use?