This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills and have John Sonmez on-line!
See this thread for details.
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 Soft Skills this week in the Jobs Discussion 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: 42919
    
  68
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.
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: 42919
    
  68
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