Firebird Database Connection

Ignition
1

Hi All,

I have a need to connect to a Firebird database. I’m wondering if anyone out there would be able to assist with some guidance on how to get this connection working.

TIA

2

We have done this. Have you got the Firebird JDBC Driver installed?

3

Hi Jonathan,

Yes I have downloaded jaybird 4.0.6 JDBC driver and have created a new JDBC driver on the in Ignition with the following data.

I uploaded the following JIC files from the downloaded driver ZIP to the newly created Ignition driver:

jaybird-4.0.6.java11
jaybird-4.0.6.java11-javadoc
jaybird-4.0.6.java11-sources
jaybird-full-4.0.6.java11

I have entered the following for the driver fields:

Name: Jaybird 4.0.6
Desc: Driver for Firebird Database
Class Name: org.firebirdsql.jdbc.FBDriver (Not sure if this is correct)
Driver Type: FIREBIRD
URL Format: jdbc:firebirdsql://host[:port]/
URL Instructions - Blank
Default Connection Properties: Blank
Connection Property Instructions : Blank
Default Validation Query: SELECT 1
Default Translator: MSSQL

I’m not sure if I’m on the right path with what I’ve done so far.

Jayden

4

Couple things to change.

URL Format: jdbc:firebirdsql:host[/port]:/path/to/db.fdb

Example: jdbc:firebirdsql:10.1.1.1/3050:C:\dbLocation\dbFile.fdb

Default Translator should be Firebird also

5

Thanks Jonathan,

I’ll check these settings, I don’t think it gave me an option to select Firebird as the default translator. I’ll check again.

Jayden

6

For posterity, I found that I was getting 'Dynamic SQL error -104. Unexpected end of command" when trying to connect. And I needed to change the default validation query in the driver settings from 'SELECT 1' to 'SELECT * FROM RDB$RELATIONS' to establish a connection. I got that query from this page: Working with databases

7

Thanks, Exactly what I needed!

For testing, I connected to the built in demo database in firebird: jdbc:firebirdsql://localhost:3050/employee

Anywhere I can get the information I need for creating a firebird translator in Ignition? I have only filled out two fields in my translator so far:
Limit Syntax = FIRST {limit}
Limit Position = Front