02. Persistent HSQL Database

Added by Andrew Petro, last edited by Andrew Petro on Oct 03, 2007
Table of Contents

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.
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.