How to Access a Oracle Universal Connection Pool From JRuby Script (Doc ID 1281414.1)

Last updated on AUGUST 03, 2016

Applies to:

Universal Connection Pool - Version: 11.1.0.7.0 to 11.2.0.1.0
Information in this document applies to any platform.

Goal

The Oracle Universal Connection Pool (UCP) for JDBC is a full-featured connection pool for managing database connections not only for Oracle but also for other non Oracle databases. The advantage of using UCP with Oracle is that UCP JDBC connection pools provide a tight integration with various Oracle Real Application Clusters (RAC) Database features . The features include Fast Connection Failover (FCF), Run-Time Connection Load Balancing, and Connection Affinity.

In this example below we show how to use UCP with an Oracle Database from a JRuby client from a single instance database.

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