1 Reply Latest reply on Jul 26, 2000 2:16 AM by 3004

    Driver not capable error. Why?

      I try to access an Oracle 8i DB with the following code:
      <%@page language="java" import="java.sql.*"%>
      Driver DriverRecordset1 = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
      Connection ConnRecordset1 = DriverManager.getConnection("jdbc:odbc:celsius","UID","PW");
      PreparedStatement StatementRecordset1 = ConnRecordset1.prepareCall("SELECT * FROM CELSIUS.PERSON");
      ResultSet Recordset1 = StatementRecordset1.executeQuery();
      boolean Recordset1_isEmpty = !Recordset1.next();
      boolean Recordset1_hasData = !Recordset1_isEmpty;
      int Recordset1_numRows = 0;
      But i always get an error : Driver not capable. Can anyone help.
      BTW how do i register the CLASSPATH for the oracle drivers lcated in the lib subdirectory of my JDeveloper??

      thanks in advance