1/16

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Universal Connection Pool for JDBC Developer's Guide

• Changes in Oracle Database 12c Release 1 (12.1)

1 Introduction to UCP

• Overview of Connection Pool
  • Benefits of Using a Connection Pool
• Overview of Universal Connection Pool for JDBC
  • Conceptual Architecture
  • Connection Pool Properties
  • Connection Pool Manager
  • High Availability and Performance Scenarios

2 Getting Started

• Requirements for using UCP
• Basic Connection Steps in UCP
• Basic Connection Example Using UCP
• UCP for JDBC API Overview

3 Getting Database Connections in UCP

• Borrowing Connections from UCP
  • Using the Pool-Enabled Data Source
  • Using the Pool-Enabled XA Data Source
  • Setting Connection Properties
  • Using JNDI to Borrow a Connection
  • Connection Initialization Callback
    • Creating an Initialization Callback
    • Registering an Initialization Callback
    • Removing or Unregistering an Initialization Callback
• Setting Connection Pool Properties for UCP
• Validating Connections in UCP
  • Validate When Borrowing
  • Checking If a Connection Is Valid
• Returning Borrowed Connections to UCP
• Removing Connections from UCP
• Third-Party Integration

4 Optimizing Universal Connection Pool Behavior

• Overview of Optimizing Connection Pools
• Controlling the Pool Size in UCP
  • Setting the Initial Pool Size
  • Setting the Minimum Pool Size
  • Setting the Maximum Pool Size
• Controlling Stale Connections in UCP
  • Setting Connection Reuse
    • Setting the Maximum Connection Reuse Time
    • Setting the Maximum Connection Reuse Count
  • Setting the Abandon Connection Timeout
  • Setting the Time-To-Live Connection Timeout
  • Setting the Connection Wait Timeout
  • Setting the Inactive Connection Timeout
  • Setting the Timeout Check Interval
• Harvesting Connections in UCP
  • Setting Whether a Connection is Harvestable
  • Setting the Harvest Trigger Count
  • Setting the Harvest Maximum Count
• Caching SQL Statements in UCP
  • Enabling Statement Caching

5 Labeling Connections in UCP

• Overview of Labeling Connections in UCP
• Implementing a Labeling Callback in UCP
  • Creating a Labeling Callback
    • Example of Labeling Callback
  • Registering a Labeling Callback
  • Removing a Labeling Callback
• Using UCP with DRCP
• Applying Connection Labels in UCP
• Borrowing Labeled Connections from UCP
• Checking Unmatched Labels in UCP
• Removing a Connection Label from UCP

6 Controlling Reclaimable Connection Behavior

• AbandonedConnectionTimeoutCallback
• TimeToLiveConnectionTimeoutCallback

7 Using the Connection Pool Manager

• Using the UCP Manager
  • Connection Pool Manager Overview
  • Creating a Connection Pool Manager
  • Controlling the Life Cycle of a Connection
    • Creating a Connection Pool
    • Starting a Connection Pool
    • Stopping a Connection Pool
    • Destroying a Connection Pool
  • Performing Maintenance on a Connection Pool
    • Refreshing a Connection Pool
    • Recycling a Connection Pool
    • Purging a Connection Pool
• Accessing JMX-based Management
  • UniversalConnectionPoolManagerMBean
  • UniversalConnectionPoolMBean

8 Using Oracle RAC Features

• Overview of Oracle RAC Features
• Using Fast Connection Failover
  • Overview of Fast Connection Failover
  • Understanding Fast Connection Failover
    • What the Application Sees
    • How It Works
  • Fast Connection Failover Prerequisites
  • Example Fast Connection Failover Configuration
  • Enabling Fast Connection Failover
  • Configuring ONS
    • Overview of ONS Configuration File
    • Remote Configuration
    • Client-Side Daemon Configuration
  • Configuring the Connection URL
• Using Run-Time Connection Load Balancing
  • Overview of Run-Time Connection Load Balancing
  • Setting Up Run-Time Connection Load Balancing
• Using Connection Affinity
  • Overview of Connection Affinity
  • Setting Up Connection Affinity
    • Creating a Connection Affinity Callback
    • Registering a Connection Affinity Callback
    • Removing a Connection Affinity Callback
    • Strict Affinity Mode
• Using Global Data Services
  • Overview of Global Data Services
  • Configuration Settings of Applications Using GDS

9 Ensuring Application Continuity

• Data Source Configuration
• Connection Labeling
• Connection Initialization Callback

10 Diagnosing a Connection Pool

• Pool Statistics
• Dynamic Monitoring Service Metrics
• Viewing Oracle RAC Statistics
  • Fast Connection Failover Statistics
  • Run-Time Connection Load Balance Statistics
  • Connection Affinity Statistics
• Setting Up Logging in UCP
  • Using a Logging Properties File
  • Using UCP for JDBC and JDK API
  • Supported Log Levels
• Exceptions and Error Codes

A Error Codes Reference

• General Structure of UCP Error Messages
• Connection Pool Layer Error Messages
• JDBC Data Sources and Dynamic Proxies Error Messages

Index