02. Persistent HSQL Database

Owned by Andrew Petro
Last updated: Oct 03, 2007Version comment
1 min read

You can use the following URL/username/password to have Tomcat (uPortal) start HSQLDB in memory, while still being persistent across server restarts.

jdbcDriver=org.hsqldb.jdbcDriver
jdbcUrl=jdbc:hsqldb:file:/path/to/persistent/files/uportal.db
jdbcUser=sa
jdbcPassword=

The downside to this approach is you can't use an external tool like DbVisualizer (or similar) to connect to the database while it's running under tomcat.