How to install Oracle JDBC drivers into the standard Java path
==============================================================

download/get the oracle jdbc package file (i.e. classes12.zip)

verify content of the file: jar -tf classes.zip
oracle/sql/...

Either add the directory containing classes12.zip to the classpath
or:
copy classes.zip to $JAVA_HOME/jre/lib/ext (i.e. /usr/java1.2/jre/lib/ext)

verify jdbc connection to database:

vi JdbcTest.java

//JdbcTest.java
import java.sql.Connection ;
import java.sql.DriverManager ;
import java.sql.ResultSet ;
import java.sql.Statement ;

class JdbcTest
{
  public static void main (String args[])
    {
      try {
        Class.forName("oracle.jdbc.driver.OracleDriver");
       }
        catch (ClassNotFoundException e) {
            System.err.println (e) ;
            System.exit (-1) ;
        }
       try {

            // open connection to database
           Connection connection = DriverManager.getConnection(
             "jdbc:oracle:thin:@inet-hq02.oracle.com:1521:gitsec",
             "secadmin",  // ## fill in User here
             "test" // ## fill in Password here
            );
            // build query
            String query = "SELECT * From Test" ;

            // execute query
            Statement statement = connection.createStatement () ;
            ResultSet rs = statement.executeQuery (query) ;

            System.out.println ("Query:") ;
            while ( rs.next () )
                System.out.println (rs.getString ("logline")) ;
            connection.close () ;

        }
        catch (java.sql.SQLException e) {
            System.err.println (e) ;
            System.exit (-1) ;
            
        }
    }
}

make sure there is a db user and this user got roles "connect" and "resource".