Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# Creating or Editing a JDBC Connection Shared Resource

JDBC connection shared resources can be created or edited using the TIBCO BPM Enterprise Administrator.

Procedure
1. From the TIBCO BPM Enterprise Administrator screen, select Shared Resources Manager.

2. From the Shared Resources List in the left pane, select JDBC connection.
3. Expand JDBC connection menu and click to add a new shared resource, or select an existing shared resource to edit it.
4. 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.

5. Click Save.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.