Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 15 Shared Resources : JDBC Connection

JDBC Connection
The JDBC Connection resource describes a JDBC connection. JDBC connections are used with backing stores (see Chapter 30, JDBC Backing Store Setup) and with database concepts (available in the TIBCO BusinessEvents Data Modeling add-on). This section provides a reference to the fields. For procedures see Adding a Shared Resource.
Wizard and Configuration Tab
The Wizard and Configuration tab have the following fields.
TIP: Using global variables makes the project more portable
com.ibm.db2.jcc.DB2Driver (supported for database concepts only)
See Connection Pooling for more details, including related settings that override this setting.
The initial context factory class for accessing JNDI. (javax.naming.Context.INITIAL_CONTEXT_
FACTORY
). You can choose from the drop down list of supported classes, or you can type in a different InitialContextFactory class name.
The URL to the JNDI service provider (javax.naming.Context.PROVIDER_URL). An example URL is provided when one of the supported JNDI context factory classes is selected.
The user name to use when logging into the JNDI server (javax.naming.Context.SECURITY_
PRINCIPAL
). If the JNDI provider does not require access control, this field can be empty.
The password for logging into the JNDI server (javax.naming.Context.SECURITY_
CREDENTIALS
). If the JNDI provider does not require access control, this field can be empty.
Connection Pooling
TIBCO BusinessEvents creates a pool of JDBC connections for every JDBC Connection shared resource that uses the JDBC connection type. The maximum size of this pool is specified by the Maximum Connections configuration field.
Resources such as backing stores and database concepts that use this JDBC Connection resource are given a connection from the pool. Once the maximum number of connections is reached, resources requesting a connection cannot proceed. Once a connection is freed by an activity, the connection is returned to the pool. Connections that are left open will eventually time out and be closed. These connections can be reopened at a later time, until the maximum number of connections specified in this field is reached.
For backing store connections, you can use additional connection pool properties, which override equivalent settings in the JDBC Connection resource. See Configuring Backing Store Settings and Properties for details.
Test Connection Button
The Test Connection button allows you to test the connection specified in the configuration of this resource. See Enabling the Test Connection Feature for a step you must take to enable the connection to work.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved