This documentation is about a version that is out of support, here is the latest documentation version.

How about downloading a newer, supported version?

Default database connector configuration

The Bonita Studio includes a generic database connector that allows both JDBC and Datasource configurations

There are two types of configuration for database connectors:

  • A JDBC connector is a point-to-point connection configured with information to access the database directly.

  • A datasource connector is a connection to a datasource that is an intermediate point between the user (the Bonita process) and the database.
    The advantage of using a datasource is that it can use a connection pool. The details of how the datasource retrieves information and the database it uses are hidden from the connector.

How to configure a JDBC connector

These configuration steps are the same for all database connectors except the datasource connector.

  1. Select the Database connector, for example, JDBC 4 database query. Click *Next*.

  2. Enter the Name, description, event anderror message (if any). Click *Next*.

  3. Select the .jar file of the database driver. Click *Next*.

  4. Enter the Access information. Click *Next*.

  5. Enter the Input query. This is a query to send to the database. You can put single or multiple queries separated by a separator. You can also use the graphical query builder to specify the query. Click *Next*.

  6. Choose how you want to specify the operations on connector outputs. Choose Graphical mode or Scripting mode.
    The Graphical mode does not require scripting. Click *Next*.

  7. Specify the output operations, using the Graphical mode or using expressions.

  8. In the Edit expression window, set the provided variable to get data from the external database.

  9. Click *Finish*.

in the return type, the type of the variable from the database must match the type of variable which is saved to the process variable.

How to configure a datasource connector

Before you can configure the datasource connector, you need to configure the datasource itself, which is done in the application server.
Follow the instructions in your application server documentation. See here for an example using Tomcat with PostgreSQL.
Configure the connections of the datasource to be created with auto commit set to true.
Make sure that all elements using connections return them to the pool with auto commit still set to true.

A datasource connector can be used in a Database Connection Pool (DBCP). A DBCP is a group of connections. Multiple connections are "reserved" and used as needed.

To configure the datasource connector, you need the following information:

  • The datasource name (for example java:/comp/env/yourDataSource).

  • Optionally, depending on how the datasource is configured, the properties needed to access it. These are specified as name-value pairs.

To configure the datasource connector, follow these steps:

  1. Select the Datasource database query connector. Click *Next*.

  2. Enter the Name, Description, Event and error message (if any). Click *Next*.

  3. Specify the datasource name and, optionally, properties. Click *Next*.

  4. Enter the Input query. This is a query to send to the database. You can put single or multiple queries separated by a separator. You can also use the graphical query builder to specify the query. Click *Next*.

  5. Choose how you want to specify the operations on connector outputs. Choose Graphical mode or Scripting mode. The Graphical mode does not require scripting. Click *Next*.

  6. Specify the output operations, using the Graphical mode or using expressions.

  7. In the Edit expression window, set the provided variable to get data from the external database.

  8. Click *Finish*.