Firebird SGDB Connector

Hello,

someone already used the jaybird to connect to Firebird DBMS? or used some other driver?

 

In the list of Connectors (in the menu, "Development"), you will find a Database section. In this section, we provide connectors for most of SQL databases.

However, if you want to use a database that is not in this list, but this database has a JDBC 4 driver, so you can look in the subsection "Generic", and use the "JDBC 4 database query" connector. Please have a look at the screenshot below:

Then, you just have to add your SQL query and manage the data you get.

Hello,

Becareful to add the driver you want to use in your configuration:

-> Configure -> Process dependencies -> Others ->Add...->Select your driver-> Check the dependency to add it.

To ease those steps, latest version of Bonita BPM have a driver association preference.

->Prefrences->Database Driver->Select the generic JDBC connector in the list-> Add your driver in the driver list-> Set your driver as active.

Then when using the Generic JDBC driver it will automaticaly use your driver and add it as a connector dependency.

Regards. 

I use BonitaBPMCommunity-7.1.2 on Win10 64bit and installed driver from http://www.firebirdsql.org/en/jdbc-driver/

First I don´t know if I have to use the jaybird-2.2.9.jar or the connector-api-1.5.jar.

Second I got with both following error message:
java.lang.reflect.InvocationTargetException org.bonitasoft.engine.bpm.connector.ConnectorExecutionException: USERNAME=install | org.bonitasoft.engine.core.connector.exception.SConnectorException: org.bonitasoft.engine.connector.exception.SConnectorException: java.util.concurrent.ExecutionException: org.bonitasoft.engine.connector.exception.SConnectorException: org.bonitasoft.engine.connector.ConnectorException: java.lang.ClassNotFoundException: org.postgresql.Driver

Someone knows what I did wrong ?

hello, is there a jdbc driver for Firebird ? Do you want to use it as main database, of just in a connector ? is it for v5 or v6 of Bonita ?

There is, actually.

http://www.firebirdsql.org/en/jdbc-driver/

hello,

1- sim existe o driver, como mencionado pelo rafael.vianna http://www.firebirdsql.org/en/jdbc-driver/

2- as connector to interact with existing database.

3- v6

I tried importing the JDBC driver to connect, but it still fails...