Initializing a Firebird Database

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

Start Firebird's isql program.
Create database:

SQL> create database 'c:\trackstudio.gdb' user 'sysdba' password 'masterkey';

Connect to the database:

Copy Code

SQL> connect 'c:\trackstudio.gdb' user 'sysdba' password 'masterkey';
Commit current transaction (y/n)?y
Committing.
Database: 'c:\trackstudio.gdb', User: sysdba

TrackStudio SA: exit from isql:

Copy Code

SQL> exit;

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.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

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:

Copy Code

SQL> in trackstudio-firebird.sql;

Notes

Before upgrading the database, execute the following:

Copy Code

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

Topic path: Installation Guide > Creating and Managing the Database > Initializing a Firebird Database