01. Starting HSQL

Owned by Andrew Petro
Last updated: Mar 20, 2008 by Eric DalquistVersion comment
1 min read

Overview

Both the quick-start and uPortal only distributions come pre-configured such that the HypersonicSQL is used as the default database. Both distributions also provide ant targets which can be used to start and stop a HSQL database to use for development and testing.

Running HSQLDB:

With the quick-start distribution the ant 'start' and 'stop' targets start and stop both the hsqldb instance uPortal uses and the Tomcat instance uPortal is deployed to.

For the uPortal only distribution "ant hsql" will start the database and the "ant hsql-shutdown" target will stop it. Doing a CTRL^C in the window running the hsql database will also stop the database. The "-Dspawn=true" option can be specified with "ant hsql" to start the database in the background.