Graduate Windows Lab

Since a Firewall sits between the Oracle Database Server and the Oracle Client the JDBC connect string has to account for that. The steps below walk a user on using Oracle jdbc drivers to connect to the database.

1. Whether you use TYPE-II JDBC-OCI driver (requires the Oracle-9i Rel2 thick client) or TYPE-IV JDBC-THIN driver a copy of the oracle client is necessary when connecting from home.
   
2. A copy of the Oracle 9i Rel2. (Thick client) is available at the following location:
   http://www.oracle.com/technology/software/products/oracle9i/index.html
   
3. If JDBC thin client is used to connect to the database then OS specific Oracle InstantClient can be downloaded from the following location: http://www.oracle.com/technology/tech/oci/instantclient/instantclient.html
   
4. To download the client software from the above links may require users to do a free registration on Oracle technet.
   
5. Copies of sample programs which have connection information to the database using both JDBC-THIN and JDBC-OCI drivers can be obtained by downloading the file JDBC.zip. A checklist of common CLASSPATH issues that need to be addressed is also available in the zip.
   JDBC.zip

NOTE: When connecting to the database from inside the DEPT/GRADLABS only Oracle Instant Client is available on the machines which is JDBC-THIN compliant. Running programs which use JDBC-OCI to establish a connection to the oracle server will thus fail to make a connection from the GRADLABS because of incompatibilty.