File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Non-CSV, Flat File JDBC Driver

 
Tom Purl
Ranch Hand
Posts: 104
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
JohnsonxxxxNatexxxxx11/12/1976
PurlxxxxxxxxTomxxxxxx09/03/1977
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!
Tom
[ November 04, 2002: Message edited by: Tom Purl ]
[ November 04, 2002: Message edited by: Tom Purl ]
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic