Last week, we had the author of TDD for a Shopping Website LiveProject. Friday at 11am Ranch time, Steven Solomon will be hosting a live TDD session just for us. See for the agenda and registration link
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
  • Piet Souris
  • Himai Minh

Non-CSV, Flat File JDBC Driver

Ranch Hand
Posts: 104
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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)
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 ]
catch it before it slithers away! Oh wait, it's a tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
    Bookmark Topic Watch Topic
  • New Topic