Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

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

2 Getting Started

• Requirements
• Basic Connection Steps
• Basic Connection Example
• UCP for JDBC API Overview
• Setting Up Logging
  • Using a Logging Properties File
  • Using UCP for JDBC and JDK API
  • Supported Log Levels

3 Getting Database Connections

• Borrowing Connections
  • Using the Pool-Enabled Data Source
  • Using the Pool-Enabled XA Data Source
  • Setting Connection Properties
  • Using JNDI to Borrow a Connection
• Setting Connection Pool Properties
• Validating Connections
  • Validate When Borrowing
  • Checking If a Connection Is Valid
• Returning Borrowed Connections
• Removing Connections From the Pool
• Third-Party Integration

4 Optimizing Connection Pool Behavior

• Overview of Optimizing Connection Pools
• Controlling the Pool Size
  • Setting the Initial Pool Size
  • Setting the Minimum Pool Size
  • Setting the Maximum Pool Size
• Controlling Stale Connections
  • 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
  • Setting Whether a Connection is Harvestable
  • Setting the Harvest Trigger Count
  • Setting the Harvest Maximum Count
• Caching SQL Statements
  • Enabling Statement Caching

5 Labeling Connections

• Labeling Connections Overview
• Implementing a Labeling Callback
  • Creating a Labeling Callback
    • An Example Labeling Callback
  • Registering a Labeling Callback
  • Removing a Labeling Callback
• Applying Connection Labels
• Borrowing Labeled Connections
• Checking Unmatched Labels
• Removing a Connection Label

6 Using the Connection Pool Manager

• Connection Pool Manager Overview
• Creating a Connection Pool Manager
• Controlling the Lifecycle of a Connection Pool
  • 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

7 Using Oracle RAC Features

• Overview of Oracle RAC Features
• Using Fast Connection Failover
  • Example Fast Connection Failover Configuration
  • Enabling Fast Connection Failover
  • Configuring ONS
    • Remote Configuration
    • Client-Side Daemon Configuration
  • Configuring the Connection URL
• Using Run-Time Connection Load Balancing
  • Setting Up Run-Time Connection Load Balancing
• Using Connection Affinity
  • Setting Up Connection Affinity
    • Creating a Connection Affinity Callback
    • Registering a Connection Affinity Callback
    • Removing a Connection Affinity Callback
• Diagnostics and Statistics for Oracle RAC Features
  • Fast Connection Failover Statistics
  • Run-Time Connection Load Balance Statistics
  • Connection Affinity Statistics

Index