OCI driver example

import java.sql.*;
class TestOCIApp {
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:@dssora01.dss","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( );
}
}

For this example to work, the following conditions must be met:
.  You must have the Oracle8i client installed.
.  The Oracle classes12.zip file must be listed in your CLASSPATH.
.  You must have JDK 1.2.x or higher installed.
.  You must have access to an Oracle8i (or higher) database.

To compile the program, type the code into a file named TestOCIApp.java (remember, Java is case-sensitive). Be sure to change the database, username, and password to values that will work in your environment. Then, to compile and execute the program, type the commands shown in the following example:

c:\> javac TestOCIApp.java
c:\> java TestOCIApp
Hello OCI driver tester SCOTT!

For example, if your Oracle JDBC classes file is located in c:\oracle\ora81\jdbc\lib\classes12.zip, then your CLASSPATH environment variable should look something like this:
CLASSPATH=c:\oracle\ora81\jdbc\lib\classes12.zip;