This week's book giveaway is in the OCAJP forum.
We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line!
See this thread for details.
Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
karthik sambandan
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am asking about the read/write of a csv file into a database.
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
[ 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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic