Attempting to Connect to a Firebird Database

Ignition
1

I have created a local Firebird database. That database is located at D:\firebirdtest\TEST.FDB. I added the Firebird driver, provided the correct .jar file, and then I created a database connection with the connect URL as ‘D:\firebirdtest\TEST.FDB’. The database then appears with an ERROR status, reading “Cannot create JDBC driver of class ‘org.firebirdsql.jdbc.FBDriver’ for connect URL ‘D:\firebirdtest\test.fdb'“.

I’ve attempted other connect URL’s and get a connection-based error, leading me to believe that I may have set up the driver wrong, but I am open to other possibilities. Still learning to use Ignition and would very much appreciate some help.

2

Your new database connection is set up to use the Firebird JDBC driver profile you set up, correct? What's the status of that JDBC driver you added?

3

The status on the Firebird driver is “Installed”. The database connection is set to use the Firebird driver.

4

I believe I’ve sorted the driver/connect URL issues, but am now getting the following error:

Dynamic SQL Error; SQL error code = -104; Unexpected end of command - line 1, column 8 [SQLState:42000, ISC error code:335544851]

With the highlighted error line being:

at com.inductiveautomation.ignition.gateway.datasource.DelegatingStatement.executeQuery(DelegatingStatement.java:64)

5

We were able to get Firebird working with these settings on the translator and driver, big thank you to John Saunders from Inductive Automation for helping out.

Translator

Create Table Syntax: CREATE TABLE {tablename} ({creationdef}{primarykeydef})

Create Sequence Syntax: CREATE GENERATOR {tablename}_ID

Create Trigger Syntax: CREATE TRIGGER {tablename}_trigger FOR {tablename}

Create Index Syntax: CREATE INDEX {indexname} ON {tablename}({columnname})

Auto Increment Field Definition: {type} NOT NULL AUTO_INCREMENT

Alter Table Syntax: ALTER TABLE {tablename} {alterdef}

Add Column Syntax: ADD COLUMN {columnname} {type}

Primary Key Syntax: PRIMARY KEY ({columnname})

Limit Syntax: LIMIT {limit}

Limit Position: Front

Current Timestamp Query: SELECT CURRENT_TIMESTAMP FROM rdb$database

Column Quote Character: “

Fetch Key Query: SELECT max{{columnname}} FROM {tablename}

Driver

Classname: org.firebirdsql.jdbc.FBDriver

JAR file: jaybird-6.0.3.jar or equivalent

Driver Type: Firebird

URL format: jdbc:firebirdsql:10.1.1.1[/port]:/path/to/db.fdb

Default Validation Query: SELECT 1 FROM rdb$database

Default Translator: FIREBIRD

1 Like