wood burning stoves 2.0*
The moose likes JDBC and the fly likes how to load a cvs file into a oracle 9i database using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to load a cvs file into a oracle 9i database using java" Watch "how to load a cvs file into a oracle 9i database using java" New topic
Author

how to load a cvs file into a oracle 9i database using java

karthik sambandan
Greenhorn

Joined: Oct 11, 2006
Posts: 2
hi All,

please help in loading a csv file into oracle 9i database using java and retrieve it back from the database into csv file.

cheers,
karthik
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41621
    
  55
Welcome to JavaRanch.

Are you asking about how to read/write CSV files, or how to to use JDBC to access a database? If the former, have a look at the various CSV-handling libraries listed here in the "Excel" category.


Ping & DNS - my free Android networking tools app
karthik sambandan
Greenhorn

Joined: Oct 11, 2006
Posts: 2
i am asking about the read/write of a csv file into a database.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41621
    
  55
You can's save CSV file into a database directly, or read from a database directly into a CSV file. Do it in two steps: first read the file into memory (using one of the libraries mentioned in the page I linked to), and then add JDBC code to store the data in the database. Same for reading the data: first read it from the database, and then store it in a file.
Richard Thatch
Greenhorn

Joined: Feb 16, 2007
Posts: 12
[ UD: Please don't post unrelated questions into an existing topic. That's called "hijacking" and generally frowned upon. Please start a new thread instead. ]
[ March 20, 2008: Message edited by: Ulf Dittmer ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to load a cvs file into a oracle 9i database using java