This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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)?
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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com