|
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
| 
