Creating or Editing a JDBC Connection Shared Resource
JDBC connection shared resources can be created or edited using the TIBCO BPM Enterprise Administrator.
- Procedure
- From the
TIBCO BPM Enterprise Administrator screen, select
Shared Resources Manager.
- From the Shared Resources List in the left pane, select
JDBC connection.
- Expand JDBC connection menu and click
to add a new shared resource, or select an existing shared resource to edit it.
- Configure the JDBC connection shared resource using the following descriptions:
Connection details Property Description General Name (Required) The unique name of the JDBC connection shared resource. Description A description of the JDBC connection shared resource. Connection URL (Required) The URL required to connect to the database. A template of the URL is supplied for the driver you select in the Driver Class field or you can type the URL: jdbc:postgresql://<servername>:<portnumber>/<dbname>
Username (Required) The username used to authenticate connections to the server. Password (Required) The password used to authenticate connections to the server. Driver Class (Required) The name of the JDBC driver class. You can select from a dropdown menu of supported drivers.
SSL Enable SSL Enable SSL connections. When the check box is selected, the SSL Client Provider Name field is displayed.
Default: Not selected.
SSL Client Provider Name (Required if Enable SSL is selected.) The name of an SSL Client Provider. For more details, see SSL Client Provider Shared Resources.
Advanced Property Description Connection pool and cache Pool initial value The initial number of connections maintained in the pool. Pool min value The minimum number of connections in the pool.
Pool max value The maximum number of connections in the pool. Statement cache The size of the prepared statement cache in the connection pool that is created.
Default: 0 (No statement cache)
Timeout Read timeout The number of milliseconds required to receive the response from the server.
Default: 60000
Connection Timeout The number of milliseconds to wait for a connection to be established before timing out.
Default: 60000
Referencing applications
A list of applications using the JDBC connection shared resource is displayed.
- Click Save.