OTN Home > Oracle WebLogic Server 12.2.1.3.0 Documentation > Administration Console Online Help > Create UCP data sources

Administration Console Online Help

Previous Next Open TOC in new window
Content starts here

Create UCP data sources


A UCP data source is used to provide access to other data sources in your environment. see Using Universal Connection Pool Data Sources.

To create a UCP 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. In the Domain Structure tree, expand Services, then select Data Sources.
  3. On the Summary of Data Sources page, click New and select UCP Data Source.
  4. On the Create a UCP Data Source page, enter or select the following information:

    Name - Enter a name for this JDBC data source. This name is used in the configuration file (config.xml) and throughout the Administration Console whenever referring to this data source.

    Scope - Specifies if the data source is accessible within the domain, a partition, or a resource group template.

    JNDI Name - Enter the JNDI path to where this JDBC data source will be bound. Applications look up the data source on the JNDI tree by this name when reserving a connection.

    Database Type - Select the DBMS of the database that you want to connect to. If your DBMS is not listed, select Other.

    Database Driver - Select the JDBC driver you want to use to connect to the database.

  5. Click Next to continue.
  6. Optionally, use this page to define connection properties, the properties displayed depend on the driver you selected on the previous page. If you prefer, you can enter the connection properties in the Properties attribute on the next page.
  7. Click Next to continue.
  8. Enter or select the following information:

    Driver Class Name - The full package name of JDBC driver class used to create the physical database connections in the connection pool.

    URL - The URL of the database to connect to.

    JNDI Name - Enter the JNDI path to where this JDBC data source will be bound. Applications look up the data source on the JNDI tree by this name when reserving a connection.

    Database User Name - Database user name.

    Password - Select the JDBC driver you want to use to connect to the database.

    Properties - The list of properties passed to the JDBC driver that are used to create physical database connections.

    System Properties - The list of System Properties names passed to the JDBC driver that are used to create physical database connections.

  9. Optionally, click Test Configuration to test the database connection.
  10. Click Next to continue.
  11. On the Select Targets page, select the servers or clusters on which you want to deploy the data source.
  12. Click Finish to save the UCP data source configuration and deploy the data source to the targets that you selected.
  13. 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