How to set up examples in the Java Server Pages Book using Tomcat - InstantDB

1. Install InstantDB following its own installation guide (I unzipped it into D:\idb)

2. After making sure that your CLASSPATH includes InstantDB's jar files, run InstantDB's small database browser

java -ms16m -mx32m com.lutris.instantdb.DBBrowser

3. To make it simple, I used the sample instance provided by default installation (sample.prp)
    Create three tables by running this script

4. Edit these files in the example

ch9/store.jsp
ch9/find.jsp
ch9/delete.jsp

ch10/authenticate.jsp
ch10/updateprofile.jsp
ch10/admin/store.jsp
ch10/search/find.jsp
ch10/search/delete.jsp

ch11/store.jsp

 
FROM TO
<ora:useDataSource id="example" 
className="sun.jdbc.odbc.JdbcOdbcDriver" 
url="jdbc:odbc:example" />
  <ora:useDataSource id="example" 
className="com.lutris.instantdb.jdbc.idbDriver" 
url="jdbc:idb:D://idb//Examples//sample.prp" />

Copy idb.jar and jta-spec1_0_1.jar from D:\idb\classes to $TOMCAT_HOME/webapps/ora/WEB-INF/lib directory and re-start the server

I hope this will help.