HSQL

Common

Create a database

Creating the physical database file:

The database is automatically generated (if not exist) when running server

 <HSQL>/demo/runServer -database plazma

After run this command will be created the database plazma in folder <HSQL>/data

Creating a structure of database and populate init data:

After starting the server, you have to run the manager

 <HSQL>/demo/runManager

Next you have to connect to the database by selecting the type of connection with HSQL Database Engine Server

Now you have to download (File -> Open Script ...) and perform (Execute) initialize SQL script.


  <Plazma>/db/script/createdb/hsql/en/create_plazma_db.sql

JDBC driver

You have to check the JDBC driver:


 <Plazma>/lib/hsqldb.jar

You have to verify CLASSPATH for the JDBC driver in the file:


 <Plazma>/plazma.classpath
 ------------------------------------------------------
 # HSQL 
 lib/hsqldb.jar

Connect to a database

To connect you have to change properties in file <Plazma>/conf/jdbc.properties.

For example:

 # Set connection properties

 jdbc.driverClassName=org.hsqldb.jdbcDriver
 jdbc.url=jdbc:hsqldb:hsql://localhost
 #jdbc.url=jdbc:hsqldb:file:${user.dir}/db/hsql/plazma
 jdbc.username=sa
 jdbc.password=