01. Starting HSQL

Overview

Both the quick-start and uPortal only distributions come pre-configured such that the HypersonicSQL is used as the default database. The quick-start distribution includes a copy of the database and you may with to initially deploy using HSQLDB if you have downloaded the uPortal only release as well. You will need to download a copy of the database following the instructions on the HypersonicSQL page.

Running HSQLDB:

Got to the directory where HSQLDB was downloaded and deployed and run the class org.hsqldb.Server with arguments -port 8887 -database uPortalDb

the uPortalDB string must match the database name as defined in the rdbm.properties file

Starting HSQLDB with Ant

The following code can be copied either to the HSQLDB directory as a file called build.xml:

<project name="HSQLStart" default="hsql" basedir=".">
<property environment="env"/>
<!--
  The "hsql" target starts HSQL
-->

<target name="hsql">
   <echo message="Starting HSQL"/>
   <echo message="Using: ${basedir}/data/${dbName}_uPortal"/>

   <java fork="true" maxmemory="256M" dir="${basedir}" classname="org.hsqldb.Server">
      <classpath>
         <pathelement path="${basedir}/lib/hsqldb.jar"/>
      </classpath>
      <arg value="-database"/>
      <arg value="${basedir}/data/${dbName}_uPortal"/>
      <arg value="-port"/>
      <arg value="8887"/>
   </java>
</target>
<!--
  The "help" target prints a help message
-->
-
<target name="help">
   <echo message="ant hsql -DdbName={HSQLDatabaseName}"/>
   <echo message="Known databases:"/>
</target>
</project>

From the HSQLDB directory run :

'ant hsql -DdbName=UP3'

See note above regarding the database name: