Initializing Firebird Database

This section describes how to configure Firebird/Interbase database.

1. Start Firebird's isql program.

2. Create database

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

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

4. TrackStuido SA: exit from isql:

SQL> exit;

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

6. Initialize the database:

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

SQL> in trackstudio-firebird.sql;

Notes

Before upgrade the database, execute the following:

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

Topic path: Installation Guide > Creating and Configuring Database > Initializing Firebird Database

Contents | Index