Java Programming with Oracle JDBC

Installation

Installing the JDBC drivers varies depending on whether you use the OCI driver or the Thin driver. Let’s start with the OCI driver installation.

Installing the OCI Driver

To install the OCI driver software, follow these steps:

1. Install the Oracle client software from its distribution CD.

2. Add the appropriate classesXXX.zip file to your CLASSPATH environment variable.

3. If you are using Java 2 Enterprise Edition (J2EE), add the appropriate classesXXX.zip file to your J2EE_CLASSPATH environment variable.

4. Add the client binaries to your PATH environment variable.

5. On Unix or Linux, add the client binaries to the LD_LIBRARY_PATH environment variable.

Install the Oracle Client

If you are going to use the OCI driver, you’ll need the Oracle8i Oracle Client distribution media or the Oracle Enterprise Edition distribution media (typically, these are on CD-ROM) to install the client software. Follow your operating-system-specific instructions to execute the Oracle Universal Installer. Then simply follow the installation instructions from the Oracle Universal Installer’s screen.

The Oracle Universal Installer creates several directories during the installation of the client software on your computer. The directories of interest to you are all under ORACLE_HOME\jdbc. ORACLE_HOME refers to the directory where the Oracle client software was installed. Typically, these directories are:

demo/samples

Contains Oracle’s sample programs, demonstrating the use of SQL92 and Oracle SQL syntax, PL/SQL ...