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.