This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes CSV to JDBC reader Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "CSV to JDBC reader " Watch "CSV to JDBC reader " New topic

CSV to JDBC reader

Peter Rooke
Ranch Hand

Joined: Oct 21, 2004
Posts: 820

I'm looking at using a tool to parse CSV files, as if they were database tables. Have found two tools:

ii) xlSQL

My question is, and in terms of stability and extensibility which would be the preferred tool?

Regards Pete
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

Two questions for you...

Can you use a database? Why not write your own csv parser?

CSV files are just text files with a fancier name. While I'm sure those two packages you listed may have many special features and abilities for general database storage, something simpler and more custom may prove more applicable in your situation. The performance really depends on what you are going to do with it, and for something as simple as a CSV file, I'd probably want to write my own.

[OCA 8 Book] [Blog]
Peter Rooke
Ranch Hand

Joined: Oct 21, 2004
Posts: 820

Why not write your own
- Yes could do, but if there is a proven tool out there, would like to have a look at it. If I write something, I'm not convinced that it will be tested as fully as a tool developed as open source. Also want to get into the interesting parts of this project, and not spending time grinding code for a solution that has been done before.

Years back, had to write an Informix 4GL XML parser (well sort of :roll: ) for an old Informix database - did'nt enjoy this.

Mind you by the time I find any documentation for xlSQL - I could have written my own utility.
[ May 05, 2006: Message edited by: Peter Rooke ]
I agree. Here's the link:
subject: CSV to JDBC reader
It's not a secret anymore!