JDBC Connection Resource
During the design time, the JDBC connection resource creates a connection between the plug-in and supported databases.
During the runtime, the JDBC connection resource details is used to create a connection between the plug-in and supported databases.
The JDBC connection resource has two tabs; General and JDBC Connection.
General
The General panel contains the following fields.
| Property | Module Property? | Description |
|---|---|---|
| Package | No | The name of the package where the JDBC connection resource is added. |
| Name | No | The name to be displayed as the label for the JDBC shared resource in the process. |
| Description | No | The name to be displayed as the label for the JDBC connection resource. |
JDBC Connection
In the JDBC Connection panel, you can specify the connection details to establish a connection with Change Data Capture. The following fields are included in the JDBC Connection panel.
| Property | Module Property? | Description |
|---|---|---|
| Connection Type |
Yes | The Connection Type used is Direct |
| Maximum Connections | Yes | The maximum number of connections that can be established |
| Login Credentials | Yes | The database credentials used for creating a connection |
| Username | Yes | Enter the username of the database to be used for authentication |
| Password | Yes | Enter the password of the database to be used for authentication |
| Database Driver | Yes | Select the class for the database driver |
| Database URL | Yes | It is a connection string representing host port and database name |
| Login Timeout (secs) | Yes | The time (in seconds) to wait before timing out when establishing a connection. The default login timeout is 30 seconds. |
| Connection Idle Timeout | Yes | The maximum length of time (in seconds) that a connection is idle until any activity is performed. The default connection idle timeout is 300 seconds. |