Get your CodeRanch badge!*
The moose likes JDBC and the fly likes JDBC and TextFiles Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC and TextFiles" Watch "JDBC and TextFiles" New topic
Author

JDBC and TextFiles

vishal sodani
Ranch Hand

Joined: Aug 26, 2000
Posts: 127
Hi,
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?
thanks
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.
http://java.sun.com/docs/books/tutorial/essential/io/rafIO.html
Jamie
[ February 05, 2002: Message edited by: Jamie Robertson ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC and TextFiles
 
Similar Threads
experience with databases and jdbc-drivers
Help a beginner create a database! ;-)
Compression/Decompression encoding in unix.
save as text
Accessing text files outside eclipse