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 novice: want to connect to oracle 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 "novice: want to connect to oracle" Watch "novice: want to connect to oracle" New topic

novice: want to connect to oracle

John Kilbourne
Ranch Hand

Joined: Aug 22, 2001
Posts: 30
I'm working with Horton's beginning java book, and can do the examples with Access, but I want to try with oracle. I downloaded the driver from oracle, a zip with about 40 separate files. I am a bit overwhelmed, and just want to repeat what I did with the access database from the Ivor Horton beginning Java book. That was easy b/c the odbc driver is built in. Can anyone direct me in the best(simplest) way to install the driver(s). I've heard that it is pretty difficult.
Thanks in advance.
Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
It's not really that difficult. I don't have much experience connecting to an Oracle DB, but it should be the same. Just stick the downloaded JDBC driver file (I think it's .zip) into your classpath and then you can start using it!
Marcos Maia
Ranch Hand

Joined: Jan 06, 2001
Posts: 977
You have to point your classpath to the oracle driver classes, I�ve put some code samples about how to get a connection from oracle at:
take a look if you need.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: novice: want to connect to oracle
jQuery in Action, 3rd edition