How To Use EclipseLinkJPACacheStore With Universal Connection Pool For Fast Connection Failover And Run-Time Connection Load Balancing (Doc ID 1335149.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle TopLink - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Aug-2013***

Goal

The example "tlgridcachestore2" demonstrates how to use EclipseLinkJPACacheStore, a feature of TopLink Grid, together with Oracle Universal Connection Pool (UCP).

This will allow EclipseLinkJPACacheStore to use the UCP features "Run-Time Connection Load Balancing" (RCLB) and "Fast Connection Failover" (FCF) among other advanced features when connected to Oracle Real Application Cluster (RAC).

FCF allows to detect disappearing and joining RAC nodes very quickly using Fast Application Notification (FAN). This does guarantee that application caused by dead database connections are kept at a minimum.

RCLB allows to balance the workload across RAC nodes even with dynamically changing RAC configurations, for example if RAC nodes join and leave the cluster.

WebLogic Server >= 12.1.2 is shipping with a feature called "Managed Coherence Servers". Since this version the "Managed Coherence Servers" have all the WebLogic Server services available including GridLink data sources.

GridLink data sources uses Universal Connection Pool (UCP) implicitly to provide support for RAC features like FCF and RCLB.

But for all other environments, like WebLogic Server < 12.1.2, the example issued in this article explains how to make use of this advanced RAC features.

Note:
The solution described in this document is not required for a WebLogic Server > 12.1.2 environment. Managed Coherence Instances have all the WebLogic Server services available. So EclipseLink can be configured with a JNDI name defined for a GridLink data source. GridLink does support the advanced features of RAC like FCF and RCLB.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms