Re: JDBC java drivers + Oracle 8.1.7 + Red Hat 7.0

Hi,

I am trying to connect to Oracle 8.1.6 on NT4.0 .I have code in application like this

import java.sql.*;

class QueryExample
{
  public static void main (String args [])

       throws SQLException
  {

     // Load the Oracle JDBC driver
    DriverManager.registerDriver(new
oracle.jdbc.driver.OracleDriver());

// Connect to the database
// databasename = db name on my machine
    Connection conn =
      DriverManager.getConnection ("jdbc:oracle:oci8:@" + databasename,

                                   "scott", "tiger");

    Statement stmt = conn.createStatement ();     ResultSet rset = stmt.executeQuery ("select ENAME from EMP");     while (rset.next ())
      System.out.println (rset.getString (1));   }
}

When I compile I am getting this error:class oracle.jdbc.driver.OracleDriver not found in type declaration or import.

No constructor in OracleDriver matches<init>() DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

I don't know,what I am missing.some help would be appreciated.By the way I added
classes111.zip,nls_charset11.zip to CLASSPATH. Received on Tue Aug 21 2001 - 14:54:22 CDT