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

    Driver not capable error. Why?

    3004
      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");
      StatementRecordset1.setQueryTimeout(0);
      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
      alex
      null