5 JDBC GridLink Data Source Configuration (optional)

You can optionally configure the WebLogic server GridLink data source to distribute database connections to Oracle RAC instances.

Before you create a multi-data source, edit the existing generic data source, create the generic data sources that the multi-data source will manage, and deploy them to the same targets where you want to deploy the multi-data source. You can create data sources and multi-data sources in a single edit session.

  1. Edit the Existing Generic Data Source

  2. Create the JDBC GridLink Data Source

5.1 Edit the Existing Generic Data Source

In the Administration Console, in the Change Center, click Lock & Edit.
In the Domain Structure tree, expand Services and select Data Sources.
Select the desired data source and, under the Configuration tab, select General.
Change JNDI Name to a unique value.

Note: You can use a numeric suffix, like -1, to make a value unique. For instance, you can change "jdbc/OHF-ODB" to "jdbc/OHF-ODB-1"..

Click Save to save the JDBC data source changes.
In the Administration Console, in the Change Center, click Activate Changes.

Note: Not all changes may take effect immediately. Some changes may require a restart.


5.2 Create the JDBC GridLink Data Source

Follow the instructions described in https://support.oracle.com/epmos/faces/DocumentDisplay?&id=1382656.1, using the following parameters:

The data source Name and JNDI Name must be unique.
Use the JNDI Name used by the application. For OMICS, this is jdbc/OHF-ODB.
Use the following default values for OHF Data Source creation:
  • Add the following value to Properties: oracle.jdbc.defaultRowPrefetch=100

  • Initial Capacity: 10

  • Maximum Capacity: 10

  • Minimum Capacity: 10

  • Wrap Data Types: Unchecked for Omics Data Source