Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

Enable Set Client ID On Connection for a JDBC data source


If Set Client ID On Connection is selected on a data source, when an application requests a database connection from the data source, WebLogic Server determines the current WebLogic Server user ID and then sets the mapped database ID as a light-weight client ID on the database connection.

Note:

This feature relies on features in the JDBC driver and DBMS. It is only supported for use with Oracle and DB2 databases and with the Oracle Thin and DB2 UDB JDBC drivers, respectively.

To configure homogeneous credential-based Pooling for a JDBC data source:

  1. If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
  2. Navigate to the data source that you want to modify:
  3. Select the Configuration: Identity Options tab.
  4. Select the Set Client ID On Connection check box and then click Save.

    Note: Set Client ID On Connection and Enable Identity Based Connection Pooling are mutually exclusive. If you think you need both mechanisms to pass security credentials in your application environment, create separate data sources -- one for with Set Client ID On Connection and one with Enable Identity Based Connection Pooling.

  5. Map your WebLogic Server ID to a database ID. See Configure credential mapping for a JDBC data source.
  6. To activate these changes, in the Change Center of the Administration Console, click Activate Changes.
    Not all changes take effect immediately—some require a restart (see Use the Change Center).

Back to Top