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
We have done this. Have you got the Firebird JDBC Driver installed?
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
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
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
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
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
Hi @jonathan.taylor and Everyone,
I'm trying to connect the Firebird db to ignition. But, that was showing faulted in the Status of the Database.
Drivers and URL links are also given, as you mentioned. I'll give an images of the driver and Db config page below.
Driver Config :
I've given the image of the Jar* file I used in the driver configuration.
Database Config:
Status:
I have given the MSSQL to the translator for the advanced properties of the DB configuration.
Could anyone give me an idea or any suggestions for connecting the Firebird db?
Thanks and Regard,
Muniyandi D
When the connection faults, there should be a detailed log entry with more information. Look for that.