Overview
Hypersonic SQL is an open source Java database engine with a standard SQL and JDBC interface. It is available from Sourceforge at http://hsqldb.sourceforge.net/ . The uPortal 2.5.1 release uses the 1.7.2.4 release of Hypercontent.
Obtaining the Driver
The HypersonicSQL driver comes packaged with the database download. It is available from Sourceforge at http://hsqldb.sourceforge.net/ .
Properties Configuration
The uPortal release is initially configured to use HypersonicSQL so configuration of properties most likely will not be necessary. The information provided here is mostly provided for verification that the system is set up correctly.
...
| Code Block |
|---|
<!-- JDBC Properties -->
<driver>org.hsqldb.jdbcDriver</driver>
<url>jdbc:hsqldb:hsql://localhost:8887</url>
<logonid>sa</logonid>
<logonpassword></logonpassword>,
<uidquery>SELECT FIRST_NAME||' '||LAST_NAME AS FIRST_LAST,
FIRST_NAME, LAST_NAME, EMAIL FROM UP_PERSON_DIR WHERE USER_NAME=?></uidquery>
|
Loading the Database
Loading the database requires a couple of steps
...
NOTE: If you are working from the quickstart release the database comes packaged with the release and is preloaded so creating the database and running "ant db" is unnecessary.
Additional notes
Starting HSQL
HSQL OutOfMemoryError
Issues and Known Bugs
The Sourceforge repository contains several available releases. Prior to version 1.6.1 the HypersonicSQL database was called "hsql" instead of "hsqldb" and the driver class names were different. If using an older release the properties configuration information will need to be modified.
...