1. Start HSQL Database:

> java -cp hsqldb.jar org.hsqldb.Server -database TrackStudio

2. Configure the database connection properties:

• TrackStudio SA: Go to the Database Connectivity tab, enter the JDBC connection properties.
• TrackStudio WAR: Edit the trackstudio.hibernate.properties:

hibernate.dialect net.sf.hibernate.dialect.HSQLDialect
hibernate.connection.url jdbc:hsqldb:hsql://localhost
hibernate.connection.driver_class org.hsqldb.jdbcDriver
hibernate.connection.username sa
hibernate.connection.password

3. Initialize the database:

• TrackStudio SA: Go to the Database Management tab and click the Create Database button.
• TrackStudio WAR: Execute sql\en\trackstudio-hsql.sql:

> java -cp hsqldb.jar org.hsqldb.util.DatabaseManager