Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

suggest an API for my problem

 
sumit anand kumar
Ranch Hand
Posts: 83
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

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?
 
Ernest Friedman-Hill
author and iconoclast
Marshal
Pie
Posts: 24208
35
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Runtime.exec() and a command-line CVS client would be the simplest route. A few usable Java CVS libraries have come and gone over the years, but none have had much staying power.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic