Hypersonic SQL Servlet
How to test the Servlet
To test the Hypersonic SQL Servlet, you may use the
Java Servlet Development Kit Version 2.1 from Sun.
Here is a step-by-step documentation:
- Download the JSDK 2.1:
http://java.sun.com/products/servlet/
The file is maybe called 'jsdk2_1-win.zip'.
- Extract all files to (for example) D:\Java, so that
you have then a file D:\Java\jdsk2.1\startserver.bat.
- Copy the files hsql.jar and servletdemo.html to D:\Java\jsdk2.1\examples\servlets.
- Copy the file hsql.jar additionally to D:\Java\jsdk2.1\examples\WEB-INF\servlets.
- Expand the file here. Change to this directory and type:
jar -xf hsql.jar
- Make sure the files D:\Java\jsdk2.1\examples\WEB-INF\servlets\hsqlServlet.class
exists, and additional files in the directory D:\Java\jsdk2.1\examples\WEB-INF\servlets\org\hsql
- On Windows, run:
D:\Java\jsdk2.1>startserver
- Start a web browser and open the address:
http://localhost:8080/
- You should get the page 'Java(tm) Servlet Development Kit'
from Sun. This was only a test if the small web server is running.
- Now, open the Hypersonic SQL Servlet Demo page:
http://localhost:8080/examples/servlets/servletdemo.html
- You can also test the servlet directly, without
using the QueryTool. This will display status information:
http://localhost:8080/examples/servlet/hsqlServlet
How to clean the database
The database will write to the files 'test.*'. If it is closed
and started again, it will automatically re-load the data. To get
a a clean database, all 'test.*' files must be deleted.