Firebird

Common

Create a database

Creating the physical database file:

 <Firebird>/bin/isql

 SQL> CREATE DATABASE 'c:\DATA\plazma.fdb' USER 'SYSDBA' PASSWORD 'masterkey';
 SQL> EXIT;
 

Creating a structure of database and populate init data:

 <Firebird>/bin/isql c:\DATA\plazma.fdb -i с:\Plazma\db\script\createdb\firebird\en\create_plazma_db.sql -u SYSDBA -p masterkey
 

JDBC driver

You have to check the JDBC driver:

 <Plazma>/lib/jdbc/firebird/jaybird-full-2.1.6.jar
 

You have to verify CLASSPATH for the JDBC driver in the file:

 <Plazma>/plazma.classpath
 ------------------------------------------------------
 # Firebird 
 lib/jdbc/firebird/jaybird-full-2.1.6.jar 
 
 

Connect to a database

To connect you have to change properties in file <Plazma>/conf/jdbc.properties.

For example:

 # Set connection properties
 jdbc.driverClassName=org.firebirdsql.jdbc.FBDriver
 jdbc.url=jdbc:firebirdsql:localhost/3050:C:\\DATA\\plazma.fdb
 jdbc.username=sysdba
 jdbc.password=masterkey