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)?
Joined: Oct 20, 2001
only things that you need are the driver(classes12.zip) and you should also know the connection string to connect to the db.
Joined: Jul 27, 2002
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.