Re: InstantDB: ClassNotFoundException:jdbc.idbDriver error

----- Original Message -----

From: Aleksandr Kravets

To: instantdb@enhydra.org

Sent: Friday, April 13, 2001 10:08 PM

Subject: InstantDB: ClassNotFoundException:jdbc.idbDriver error

Hi everyone,

 

I installed InstantDB on my machine, but I get some errors. I think I installed it correctly because I can start DBBrowser and try out different SQL statements. Here is the thing though, I'am trying to run a sample servlet and all I get is error: java.lang.ClassNotFoundException:jdbc.idbDriver[jdbc.idbDriver].

Here is the source code of my servlet:

 

import javax.servlet.*;

import javax.servlet.http.*

import java.sql.*;

import org.enhydra.instantDB.jdbc.*; // do I need to include this?

 

/* All servlet-specific methods: doGet(), */

 

try{

    Class.forName("jdbc.idbDriver");

    String url = "jdbc:idb:C:\\InstantDB\\Examples\\sample.prp";

 

   Connection con = DriverMananger.getConnection(url);

   Statement stmnt = con.createStatement();

   String sql  = "SELECT * from import1";

 

   ResultSet res = stmnt.executeQuery(sql);

 

   /* rest of calls for bringing up results from ResultSet */

 

   }

   catch(SQLException exp){out.println(exp);}

   catch(Exception genExp){out.println("some exeption: " + genExp);}

}

}

 

and this is my autoexec.bat:

set CLASSPATH=c:\progra~1\allaire\jrun\lib\ext\servlet.jar;c:\InstantDB\Classes\id.jar;%CLASSPATH%

set PATH=C:\JDK1.2.2\bin

set IDB=C:\InstantDB

set JRE="C:\Program Files\JavaSoft\JRE\1.2"

set PATH=%JRE%\bin;%PATH%

set PATH=%IDB%\Classes;%PATH%

 

Any help is greatly appreciated.

 

thanks,

Alex