File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes suggest an API for my problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "suggest an API for my problem" Watch "suggest an API for my problem" New topic

suggest an API for my problem

sumit anand kumar
Ranch Hand

Joined: Apr 28, 2010
Posts: 83
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

Joined: Jul 08, 2003
Posts: 24195

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.

[Jess in Action][AskingGoodQuestions]
subject: suggest an API for my problem
It's not a secret anymore!