FileDocCategorySizeDatePackage
TestOCIApp.javaAPI DocExample706Thu Jun 14 18:11:14 BST 2001None

TestOCIApp

public class TestOCIApp extends Object

Fields Summary
Constructors Summary
Methods Summary
public static voidmain(java.lang.String[] args)


    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","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();