AppFuseWithHSQLDB

This is version 4. It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

1. Add the JDBC Driver to the lib directory.
2. Add an entry for the JAR to lib/lib.properties.
3. Change build.properties to reflect the database settings.

This page describes how to configure your AppFuse-based project to use an HSQL Database.

Table of Contents

• [1] Download and install hsqldb
• [2] Create an entry for hsqldb in lib.properties
• [3] Configure build.properties
• [4] Start HSQL and run tests

Download and install hsqldb [#1]

Download HSQLDB from SourceForge. Create a lib/hsqldb-1.7.2 directory and put hsqldb.jar in this directory.

Create an entry for hsqldb in lib.properties [#2]

Open lib/lib.properties and add the following entry:

#
# HSQLDB - http://hsqldb.sourceforge.net
#
hsqldb.version		= 1.7.2
hsqldb.dir=${lib.dir}/hsqldb-${hsqldb.version}
hsqldb.jar=${hsqldb.dir}/hsqldb.jar

Configure build.properties [#3]

Uncomment the database entries in build.properties and use the following settings (or just copy/paste these).

database.jar=${hsqldb.jar}
database.type=hsql
database.name=appfuse
database.host=localhost

hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect
database.driver_class=org.hsqldb.jdbcDriver
database.url=jdbc:hsqldb:${database.type}://${database.host}/${database.name}
database.username=sa
database.password=

Start HSQL and run tests [#4]

HSQLDB doesn't ship with a way to start and run it as a service. However, there is a way to configure HSQLDB to run as a service. Following these instructions, you can install an HSQL service running the "appfuse" database. Just download the hsql.exe and hsql_service_install.bat and change the hsql_service_install.bat to contain the following. The setttings below assume you've extracted the hsqldb download to c:\Tools\hsqldb and that you've install the downloaded files into the same directory.

net stop HSQLService
hsql.exe -uninstall HSQLService
set EAGLE_MEMEX_BIN=c:/tools/hsqldb/lib
set DATABASE=c:/tools/hsqldb/data/appfuse
set CURRENTDIR=c:/tools/hsqldb/data
hsql.exe -install HSQLService "%JAVA_HOME%\jre\bin\server\jvm.dll" -jvm_option -Xms128m -Xmx128m -Djava.class.path=".;%EAGLE_MEMEX_BIN%\hsqldb.jar" -jvm_option -Dsystem.drive="c:" -start org.hsqldb.Server -params -database.0 %DATABASE% -dbname.0 appfuse -current "% CURRENTDIR%" -out "%CURRENTDIR%/service.out" -err "%CURRENTDIR%/service.err"
net start HSQLService

Another option is to simply create script (i.e. run-hsqldb.bat) in your project's directory that you can use to start HSQLDB.

java -cp lib/hsqldb-1.7.2/hsqldb.jar org.hsqldb.Server -database.0 c:/temp/appfuse-db -dbname.0 appfuse