GeeCON Prague 2014*
The moose likes JDBC and the fly likes Is Oracle Client required????? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Is Oracle Client required?????" Watch "Is Oracle Client required?????" New topic
Author

Is Oracle Client required?????

Gaurav Jain
Ranch Hand

Joined: Mar 11, 2004
Posts: 108
If i am trying to access an Oracle DB sitting on a different machine through my Java application by using JDBC then do i need to have Oracle Client installed on my machine(on which the java application is residing)?
Gowrishankar Mudaliar
Ranch Hand

Joined: Oct 20, 2001
Posts: 39
only things that you need are the driver(classes12.zip) and you should also know the connection string to connect to the db.
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Hi Gaurav,
As so often, it depends. You 'll definitely need a .jar or .zip that contains the Oracle JDBC driver. There are different flavours available: classes12.zip is for JVMs 1.2 and higher, but there is also jdbc14.jar (not exactly sure of the name) that is for JVM 1.4 and higher (and others).
Now once you have the classes, you can use them in two ways. One option is the use as a Java-only (type 4) driver, or the Thin driver in Oracle terminology. That obviously requires nothing but the driver. The other option is to use the Oracle client libraries (type 2 driver), or the OCI driver. If you do that, you clearly need the Oracle client software, especially the OCI libraries.
Of course you can find this explained in the Oracle documentation that you can freely download (after registration).
Good riding,
Rudy.
 
GeeCON Prague 2014
 
subject: Is Oracle Client required?????