JDBC Connection
JDBC Connection resource describes a JDBC connection. JDBC connections are used when specifying activities from the JDBC palette.
General
The General section has the following fields.
| Field | Description |
|---|---|
| Package | The name of the package in which you want to create a shared resource. |
| Name | The name of the shared resource. |
| Description | A short description of the shared resource |
JDBC Connection
This section has the following fields.
| Field | Literal Value/Module Property | Description |
|---|---|---|
| Connection Type | None | Specifies the kind of JDBC connection that you want to create. |
| Maximum Connections | Yes | The maximum number of database connections to allocate. The default maximum is 10. The minimum value that can be specified is 1. |
| Login Credentials | Yes | The username used to connect to the database.
The password used to connect to the database. |
JDBC Driver
This section has the following fields.
| Field | Literal Value/Module Property | Description |
|---|---|---|
| Database Driver | Yes | The name of the JDBC driver class. If you select a supported driver from a list of supported drivers, the
Database URL field is populated with a template for the URL of the driver.
The following drivers are packaged:
In addition, the JDBC palette also supports the MySQL, Oracle, and MariaDB database. Note: The
TIBCO Business Studio for BusinessWorks product can connect with MariaDB ® or MySQL through use of MariaDB® Connector/J, which is subject to free and open-source software license terms and available at
https://mariadb.com/downloads/mariadb-tx/connector. MariaDB Connector/J is not part of the product and therefore not within the scope of your license for the
TIBCO Business Studio for BusinessWorks product. Accordingly, MariaDB Connector /J is not covered by the terms of your agreement with TIBCO, including any terms concerning support, maintenance, or warranties. Download and use of MariaDB Connector/J is solely at your own discretion and subject to the free and open-source license terms applicable to MariaDB Connector/J.
Note: For the Oracle database, only the DataDirect driver is supported.
|
| Database URL | Yes | The URL to use to connect to the database. A template of the URL is supplied for the selected JDBC driver. Supply the portions of the URL that are in angle brackets (<>). |
| Login Timeout (secs) | Yes | The length of time (in seconds) to wait for a successful database connection.
Only JDBC drivers that support connection timeouts can use this field. If the JDBC driver does not support connection timeouts, the value of this field is ignored. Most JDBC drivers support connection timeouts. |
| Connection Idle Timeout | Yes |
This option monitors the given time. When the time lapses, it cleanly closes the connection awaiting inside the pool of connections. You can provide time in any of the following units:
When you choose Minutes option and then select the Hours option, the value is rounded up to the nearest whole number. That is, 300 seconds are converted to 5 minutes or 1 hour. When you choose Hours and then select Minutes option, the rounding takes place at the most convenient whole number. That is, 1 hour becomes 60 minutes or 3,600 seconds. The default value is 300 seconds.
Note: If you enter a value less than or equal to Zero (0), the monitoring does not take place. The pool does not close any physical connection.
|
Test Connection
Click the Test Connection button to test whether the specified configuration fields result in a valid connection to a database.
Installing Supported Drivers for Run Time
If you want to use other databases, other than PostgreSQL or Microsoft SQL Server, you must add them separately. This is a one-time process for every installation of TIBCO Cloud Integration. Open the README.txt in the respective database shells at BW_HOME/config/drivers/shells/ for details on what JAR files to download, and where to add them.
To add the drivers at run time for Oracle, MySQL, DB2, or MariaDB, run the bwinstall command from BW_HOME/6.x/bin. Ensure that you run bwinstall with no arguments to access the help and instructions to add the driver to the run time.
The script creates driver bundles and adds it to that specific TIBCO® Cloud Integration environment. Any App Nodes that are created and started in that TIBCO Cloud Integration environment include the drivers automatically.
Since the drivers are part of the system and not part of each application, all the applications on a particular AppNode use the same drivers. However, this is not true for AppSpaces. The drivers belong to an AppNode and not an AppSpace.
Supported Drivers
The following database drivers are supported:
- org.hsqldb.jdbc.JDBCDriver
- org.postgresql.Driver
- oracle.jdbc.OracleDriver
- com.microsoft.sqlserver.jdbc.SQLServerDriver
- org.mariadb.jdbc.Driver
Note: To connect to MySQL Server, you can select the MariaDB native driver (org.mariadb.jdbc.Driver) from the Database Driver drop down menu.
The following Data Direct Drivers are supported:
- tibcosoftwareinc.jdbc.postgresql.PostgreSQLDriver
- tibcosoftwareinc.jdbc.sqlserver.SQLServerDriver
- tibcosoftwareinc.jdbc.oracle.OracleDriver