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

try changing oci to thin. Perhaps you don't have the supporting oci library on your machine.

Also, add
  import java.math.*;

hth,
cindy

rsonnathi wrote:

> 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 - 15:37:44 CDT