import java.sql.*;

class TestExternalConnection {

 public static String getGreeting() 
  throws ClassNotFoundException, SQLException {
  Class.forName("oracle.jdbc.driver.OracleDriver");
// or you can use:
//  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  String greeting = null;
  Connection conn = 
   DriverManager.getConnection(
    "jdbc:oracle:thin:@dssnt01:1521:dssora01", "scott", "tiger");
  Statement  stmt = conn.createStatement();
  ResultSet  rset = stmt.executeQuery(
   "select 'Hello '||initcap(USER)||'!' result from dual");
  if (rset.next()) 
   greeting = rset.getString(1);
  rset.close();
  stmt.close();
  conn.close();
  return greeting;  
 }
}