This document assumes you have access to jdk 1.1 or higher. You do not need the oracle client software installed on your client machine, but you do need classes111.zip in your CLASSPATH, If jdbc is installed on your client you can use ups to do this, otherwise download it from here and make the appropriate alterations to your environment variables.
Download and compile SimpleQuery.java into SimpleQuery.class SimpleQuery.class can then be run with the java byte-code interpreter.
% setup jdk setting up jdk % setup jdbc setting up jdbc % echo $CLASSPATH /usr/prd4/unsupported/java/jdk/v1.1.4/lib/classes.zip:/usr/prd4/unsupported/java/jdbc/v7_3_4/lib/classes111.zip:. % javac SimpleQuery.java % java SimpleQuery ------------------------------------------- Simple jdbc query demonstration program you will be prompted for an oracle username, password, server node name, SID name, and query. Examples of server node names that worked as of 12/18/98 at fnal: Server Node SID -------------------------------------------- fncduh dev1 fndauk dev2 b0dau30 ordb cdfora cdfoff1 --------------------------------------------- enter a node:cdfora enter a SID:cdfoff1 oracle userid:scott oracle password:tiger enter a query:select * from ped CID | CHANNEL | OFFSET | O_ERROR ----------------------------------- 0 | 0 | 0 | 0 1 | 1 | 1 | 1 2 | 2 | 2 | 2 %