Firebird SGDB Connector

Submitted by Anonymous on Sun, 12/01/2013 - 20:39
1
0
-1

Hello,

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

firebird
jaybird sgdb
Connector

Comments

Submitted by ttoine on Mon, 12/02/2013 - 15:25

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 ?

Permalink
Submitted by rafael.vianna on Mon, 12/02/2013 - 20:21

There is, actually.

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

Permalink
3 answers

Submitted by cf-service on Tue, 11/10/2015 - 18:14
1
0
-1

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 ?

Submitted by romain.bioteau on Thu, 12/19/2013 - 07:37
1
0
-1

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.

Submitted by ttoine on Tue, 12/03/2013 - 11:31
1
0
-1

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.

Notifications