How to Use HSQLDB with JSP

I presume that you already have a server like Tomcat installed and therefore will just concentrate on how to install HSQLDB in order to use it with JSP.

HSQLDB can be downloaded from here. After downloading extract the zip file & find a jar file named hsqldb.jar.. Copy this file into commons/lib of your web server installation . Once this is done, HSQLDB is ready for use with JSP/ Servlets.

A new database is created automatically if it does not yet exist. Just connect to the not-yet-existing database using the jdbc:hsqldb:file:«database-path» URL (should replace the last part with the path you want) with the user 'sa' and an empty password. For more on HSQLDb please visit this page.