Connecting to HSQL

  1. Configure the DBMC connection properties:
    • TrackStudio SA: On the tab Database select HSQL from the DBMS list and edit the properties of JDBC connection
    • TrackStudio WAR: Edit the connection properties in the file trackstudio.hibernate.properties:
hibernate.connection.driver_class=org.hsqldb.jdbcDriver
hibernate.connection.password=
hibernate.connection.url=jdbc\:hsqldb\:file\:tsdb/ru/tsdb;shutdown\=true
hibernate.connection.username=sa
hibernate.dialect=org.hibernate.dialect.HSQLDialect
  1. Initialize the database:
    • TrackStudio SA: On the tab Database press the button Create DB
    • TrackStudio WAR: Run the script sql\install\ru\trackstudio-hsql.sql
> java -cp hsqldb.jar org.hsqldb.util.DatabaseManager