File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Non-CSV, Flat File JDBC Driver 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 "Non-CSV, Flat File JDBC Driver" Watch "Non-CSV, Flat File JDBC Driver" New topic

Non-CSV, Flat File JDBC Driver

Tom Purl
Ranch Hand

Joined: May 24, 2002
Posts: 104
Hi, I'm fairly new to JDBC programming so please forgive me if this has been asked. I searched google and javaranch for quite a while and didn't come up with anything I could use.
I would like to use a JDBC driver to access a series of flat files, each with a different format. When I say flat file, I'm not referring to a comma-delimeted file (.csv). I'm talking about a file where each "field" is a set length. Here would be an example:
(Note: pretend that the x's are spaces)
I've found a few posts that deal with reading a csv flat file, but that won't help me. Also, I've found a few posts that detail how you would use an ODBC flat-file driver with the JDBC driver bridge. I would like to avoid this if it is at all possible since my program may run on platforms that don't typically have ODBC support.
(I know, almost every platform has some sort of ODBC support, but that's not necessarily true in practice.)
So, having said all of that, here's my questions:
1. Does anyone know if this type of driver exists? I would prefer that it be either Free, open source software or something maintained by Sun.
2. If it does exist, where would you find it? I know that the Perl community has a web page where you can access hundreds of database-access drivers. Does something similar to this exists in the Java world?
Thanks in advance for any help!
[ November 04, 2002: Message edited by: Tom Purl ]
[ November 04, 2002: Message edited by: Tom Purl ]

Tom Purl<br />SCJP 1.4
I agree. Here's the link:
subject: Non-CSV, Flat File JDBC Driver
It's not a secret anymore!