import java.sql.*;

class TestOCIHPSApp {
  // Test the Thin Host:Port:SID syntax with the OCI driver
  // THIS DOES NOT WORK

  public static void main(String args[]) 
   throws ClassNotFoundException, SQLException {

    Class.forName("oracle.jdbc.driver.OracleDriver");
    // or you can use:
    //  DriverManager.registerDriver(
    //   new oracle.jdbc.driver.OracleDriver());
    Connection conn = 
    DriverManager.getConnection(
     "jdbc:oracle:oci8:@dssnt01:1521:dssora01.com","scott","tiger");

    Statement stmt = conn.createStatement();
    ResultSet rset = stmt.executeQuery(
     "select 'Hello OCI driver tester '||USER||'!' result from dual");
    while(rset.next()) 
      System.out.println(rset.getString(1));
    rset.close();
    stmt.close();
    conn.close();
  }
}