Please help - Error using JDBC

Hi,

Probably a simple problem, but here is the message I am getting:

dbtest2.java:6: Class oracle.jdbc.driver.OracleDriver not found in type declaration.

    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

Here is the code I am running:

import java.sql.*;

class
est2{
  public static void main (String args []) throws SQLException {
// Load Oracle driver

    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());      

// Connect to the local database

    Connection conn =
      DriverManager.getConnection ("jdbc:oracle:thin:@odo:1521:cl01", "userid", "password");

// Query the employee names

    Statement stmt = conn.createStatement ();     ResultSet rset = stmt.executeQuery ("select ename from emp");

      // Print the name out
    while (rset.next ())
      System.out.println (rset.getString (1));   }

I have altered my classpath to include d:\orant\jdbc\lib (which contains classes111.zip)

If I use:

          Class.forName("oracle.jdbc.driver.OracleDriver");

instead of

    DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

It compiles OK, but when execute I get the error message:

No suitable driver

Anyone have any ideas?

Thanks,

Joel R. DeRider Received on Tue Dec 15 1998 - 07:42:49 CST