TrackStudio Enterprise 3.5
Initializing a Firebird Database

The following topic describes how to configure TrackStudio for use with a Firebird database management system.

  1. Start Firebird's isql program.
  2. Create database:
SQL> create database 'c:\trackstudio.gdb' user 'sysdba' password 'masterkey';
  1. Connect to the database:
SQL> connect 'c:\trackstudio.gdb' user 'sysdba' password 'masterkey';
Commit current transaction (y/n)?y
Committing.
Database: 'c:\trackstudio.gdb', User: sysdba
  1. TrackStudio SA: exit from isql:
SQL> exit;
  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:
hibernate.dialect org.hibernate.dialect.FirebirdDialect
hibernate.connection.url jdbc:firebirdsql://localhost/c:/trackstudio.gdb
hibernate.connection.driver_class org.firebirdsql.jdbc.FBDriver
hibernate.connection.username sysdba
hibernate.connection.password masterkey
  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-firebird.sql:
SQL> in trackstudio-firebird.sql;

Before upgrading the database, execute the following:

gfix.exe -user sysdba -password masterkey trackstudio.gdb -sql_dialect 3