Switching Database to Firebird

To use Firebird as Iotellect Server's database engine, follow the generic instructions from Switching To Another Database Engine article. Here is a list of notes specific to Firebird:

• Download Jaybird JCA/JDBC driver for your version of database server and store it on the machine running Iotellect Server. At the time of this writing, it is available at http://www.firebirdsql.org/index.php?op=devel&sub=jdbc.

• Put jaybird-full-X.X.X.jar into the /jar subfolder of Iotellect Server installation folder.

• Set Database Driver in Iotellect Server Global Configuration Setting to org.firebirdsql.jdbc.FBDriver. This is the java class name for the Firebird driver.

• The Database URL setting for the MySQL database has the following format: jdbc:firebirdsql:host[/port]:/path/to/db.fdb, where host is the IP or hostname of the  Firebird server (can be an empty string or localhost), port is port name on which Firebird server is running (omit this part of URL to use the default value), and /path/to/db.fdb is the path to database file that contains Iotellect Server's data. You can use server for the database name.

  • Windows example: if your Firebird server runs at localhost on port 3050, and Iotellect Server data is in C:dbserver.fdb, use the following URL: jdbc:firebirdsql:localhost/3050:C:\db\server.fdb.

  • Unix example: if your Firebird server runs at localhost on port 3050, and Iotellect Server data is in /var/lib/firebird/data/server.fdb, use the following URL: jdbc:firebirdsql:localhost/3050:/var/lib/firebird/data/server.fdb.

• Set Database Dialect setting to FirebirdDialect.

• Set Batch Size to zero. This is necessary since Firebird JDBC driver doesn't support batch inserts of objects with BLOB fields.

Was this page helpful?

Tell us more

Send

Thank you!