TrackStudio Enterprise 3.2
Contents | Index
Previous | Up | Next
Initializing an HSQLDB Database

The following topic describes how to configure TrackStudio for use with an HSQLDB database management system.

Description
  1. Start HSQLDB:
  • TrackStudio SA:
Copy Code
> hsql
  • TrackStudio WAR: Use the HSQLDB release supplied with TrackStudio WAR.
Copy Code
> java -cp hsqldb.jar org.hsqldb.Server -database TrackStudio
  1. Configure the database connection properties:
    • TrackStudio SA: Go to the Database -> Database Connectivity tab, enter the JDBC connection properties.
    • TrackStudio WAR: Edit the trackstudio.hibernate.properties:
Copy Code
hibernate.dialect org.hibernate.dialect.HSQLDialect
hibernate.connection.url jdbc:hsqldb:hsql://localhost
hibernate.connection.driver_class org.hsqldb.jdbcDriver
hibernate.connection.username sa
hibernate.connection.password
  1. Initialize the database:
    • TrackStudio SA: Go to the Database -> Database Management tab and click the Create Database button.
    • TrackStudio WAR: Execute sql\install\trackstudio-hsql.sql:
Copy Code
> java -cp hsqldb.jar org.hsqldb.util.DatabaseManager
Topics

Renaming an HSQLDB Database
The following topic describes how to rename an HSQLDB database.

Topic path: Installation Guide > Creating and Managing the Database > Initializing an HSQLDB Database
Copyright (c) 2002-2006. All rights reserved.
What do you think about this topic? Send feedback!