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 JDBC and TextFiles Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC and TextFiles" Watch "JDBC and TextFiles" New topic

JDBC and TextFiles

vishal sodani
Ranch Hand

Joined: Aug 26, 2000
Posts: 127
I have 4 textfiles,each having 5 columns delimited by space(eg.-- bill clinton male 34 married).Now,I want to query these files using SQL statements .Can I use JDBC to do so?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

it would be much faster and stable(no dsn setup, portablility issues, etc) using file IO - random access files.
[ February 05, 2002: Message edited by: Jamie Robertson ]
I agree. Here's the link:
subject: JDBC and TextFiles
It's not a secret anymore!