02. Persistent HSQL Database

Owned by Andrew Petro
Last updated: Feb 04, 2008 by Eric DalquistVersion comment

You can use the following URL/username/password in /uPortal/uportal-impl/src/main/resources/properties/rdbm.properties to have uPortal start a HSQLDB instance in memory, while still being persistent across server restarts.

##### Hypersonic SQL - Server mode
##### Requires first starting Hypersonic SQL with the command:
##### "ant hsql"
hibernate.connection.driver_class=org.hsqldb.jdbcDriver
hibernate.connection.url=jdbc:hsqldb:file:/path/to/persistent/files/uportal.db
hibernate.connection.username=sa
hibernate.connection.password=
hibernate.dialect=org.hibernate.dialect.HSQLDialect

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.