JAR File
--------
To compile and run JAVA programs using JDBC you need the following jar file:

/opt/oracle/jar/classes12.jar

If you are working at your home computer, transfer that file to your computer, 
and then set your JAVA IDE to consider that file. 


Connecting
----------

To be able to connect to the ORACLE server, which is behind a firewall, 
you need to set an ssh tunnel. For this execute at your home computer:

ssh2 -L 1521:oracle.csc.uvic.ca:1521 <yourusername>@u-knoppix.csc.uvic.ca
or
ssh -L 1521:oracle.csc.uvic.ca:1521 <yourusername>@u-knoppix.csc.uvic.ca

depending on your ssh client. 

This will ask you for password. Provide your password for the lab machine 
e.g. u-knoppix.csc.uvic.ca. 
Please use other lab machines as well in order to not overload u-knoppix.csc.uvic.ca. 

After setting up the ssh tunnel, you connect to localhost 
(rather than to the ORACLE server machine which is oracle.csc.uvic.ca). 


Other things you need to know to connect to ORACLE through JDBC or SQL Developer are:
port: 1521, and
SID: TEACH (uppercase)