Oracle Setup on SUN workstations at ECST

On the SUN workstations, java files are located at /usr/java

You can get the drivers and examples in the directories /opt/Oracle8i/products/8.1.7/jdbc/lib (the drivers) and /opt/Oracle8i/products/8.1.7/jdbc/demo (example code). Specifically, the Employee.java code is from /opt/Oracle8i/products/8.1.7/jdbc/demo/samples/thin/basic. Read the Readme.txt at /opt/Oracle8i/products/8.1.7/jdbc and also the one in the demo directory.

You need to have the location of the driver in your classpath
/opt/Oracle8i/products/8.1.7/jdbc/lib/classes12.zip

On Expert, files to test are at /opt/java/oracle/samples/thin including an application in Employee.java and an applet is JdbcAppletTest.java
(run using appletviewer from your account - not a web browser)
on expert the driver is at /opt/java/oracle/lib/classes12.zip

Important parts of code:


import java.sql.*;


    // Load the Oracle JDBC driver
    Class.forName ("oracle.jdbc.driver.OracleDriver");
 
    // Connect to the database
    Connection conn =
      DriverManager.getConnection ("jdbc:oracle:thin:@ect-sun.ecst.csuchico.edu:1521:ecstDB",
                                   "username", "password");

Possibly DriverManager.getConnection ("jdbc:oracle:thin:@132.241.6.18:1521:ecstDB", "username", "password");