Contents

Title and Copyright Information

Preface

• Documentation Accessibility
• Conventions

1 Introduction and Roadmap

• Document Scope and Audience
• Guide to this Document
• Related Documentation
• JDBC Samples and Tutorials
  • Avitek Medical Records Application (MedRec) and Tutorials
  • JDBC Examples in the WebLogic Server Distribution
• New and Changed JDBC Data Source Features in This Release
  • Enhanced Oracle RAC Support
  • Reorganization of JDBC Resources
  • Data Source Factories
  • Performance Enhancements
  • Connection-based System Properties
  • Keep Connection After Local Transaction

2 Configuring WebLogic JDBC Resources

• Understanding JDBC Resources in WebLogic Server
• Ownership of Configured JDBC Resources
• Data Source Configuration Files
  • JDBC System Modules
  • JDBC Application Modules
  • JDBC Module File Naming Requirements
  • JDBC Modules in Versioned Applications
  • JDBC Schema
• JMX and WLST Access for JDBC Resources
  • JDBC MBeans for System Resources
  • JDBC Management Objects in the Java EE Management Model (JSR-77 Support)
  • Using WLST to Create JDBC System Resources
  • How to Modify and Monitor JDBC Resources
  • Best Practices when Using WLST to Configure JDBC Resources
• Overview of Clustered JDBC Resources

3 Configuring JDBC Data Sources

• Understanding JDBC Data Sources
• Types of WebLogic Server JDBC Data Sources
• Creating a JDBC Data Source
  • JDBC Data Source Properties
    • Data Source Names
    • JNDI Names
    • Selecting a Database Type
    • Selecting a JDBC Driver
  • Configure Transaction Options
  • Configure Connection Properties
  • Test Connections
  • Target the Data Source
• Configuring Connection Pool Features
  • Enabling JDBC Driver-Level Features
  • Enabling Connection-based System Properties
  • Initializing Database Connections with SQL Code
• Configuring Oracle Parameters
• Configuring an ONS Client
• Tuning Generic Data Source Connection Pools
• Setting Database Security Credentials
  • Types of Data Source Pools
  • Using a User Name/Password
  • Set Client ID On Connection
  • Identity-based Connection Pooling
    • How Heterogeneous Connections are Created
    • Using Identity-based Pooling with Global Transactions
    • Using Identity-based Pooling with LLR
• JDBC Data Source Factories (Deprecated)

4 Using GridLink Data Sources

• What is a GridLink Data Source
  • Fast Connection Failover
  • Runtime Connection Load Balancing
  • Graceful Handling for Oracle RAC Outages
    • Handling for Oracle RAC Outages Prior to Oracle RAC 11.2
  • XA Affinity
  • SCAN Addresses
  • Secure Communication using Oracle Wallet
• Creating a GridLink Data Source
  • JDBC Data Source Properties
    • Data Source Names
    • JNDI Names
    • Select an XA or Non-XA Driver
  • Configure Transaction Options
  • Configure Connection Properties
    • Enter Connection Properties
    • Enter a Complete URL
  • Test Connections
  • Configure an ONS Client Configuration
    • Secure ONS Client Communication
  • Test ONS Client Configuration
  • Target the Data Source
• Enable Socket Direct Protocol for a Grid Link Data Source
• Configuring Connection Pool Features
  • Enabling JDBC Driver-Level Features
  • Enabling Connection-based System Properties
  • Initializing Database Connections with SQL Code
• Configuring Oracle Parameters
• Configuring an ONS Client
  • Enabling FAN Events
  • Configuring Generic Data Source Connection Testing
  • Using a Wallet File
• Configuring Oracle Parameters
• Tuning GridLink Data Source Connection Pools
• Setting Database Security Credentials
  • Using a User Name/Password
  • Set Client ID On Connection
• Monitoring GridLink JDBC Resources
  • Viewing Run-Time Statistics
    • JDBCOracleDataSourceInstanceRuntimeMBean
    • JDBCDataSourceRuntimeMBean
    • ONSDaemonRuntimeMBean
  • Debug GridLink Data Sources
    • JDBC Debugging Scopes
    • UCP JDK Logging
    • Enable Debugging Using the Command Line

5 Configuring JDBC Multi Data Sources

• Multi Data Source Features
  • Removing a Database Node
  • Adding a Database Node
• Creating and Configuring Multi Data Sources
• Choosing the Multi Data Source Algorithm
  • Failover
  • Load Balancing
• Multi Data Source Fail-Over Limitations and Requirements
  • Test Connections on Reserve to Enable Fail-Over
  • No Fail-Over for In-Use Connections
• Multi Data Source Failover Enhancements
  • Connection Request Routing Enhancements When a Data Source Fails
  • Automatic Re-enablement on Recovery of a Failed Data Source within a Multi Data Source
  • Enabling Failover for Busy Data Sources in a Multi Data Source
  • Controlling Multi Data Source Failover with a Callback
    • Callback Handler Requirements
    • Callback Handler Configuration
    • How It Works—Failover
  • Controlling Multi Data Source Failback with a Callback
    • How It Works—Failback
• Deploying JDBC Multi Data Sources on Servers and Clusters

6 Advanced Configuration for Oracle Drivers

7 JDBC Data Source Transaction Options

• Enabling Support for Global Transactions with a Non-XA JDBC Driver
• Understanding the Logging Last Resource Transaction Option
  • Advantages to Using the Logging Last Resource Optimization
  • Enabling the Logging Last Resource Transaction Optimization
  • Programming Considerations and Limitations for LLR Data Sources
  • Administrative Considerations and Limitations for LLR Data Sources
• Understanding the Emulate Two-Phase Commit Transaction Option
  • Limitations and Risks When Emulating Two-Phase Commit Using a Non-XA Driver
    • Heuristic Completions and Data Inconsistency
    • Cannot Recover Pending Transactions
    • Possible Performance Loss with Non-XA Resources in Multi-Server Configurations
    • Multiple Non-XA Participants

8 Using Roles and Policies to Secure JDBC Data Sources

• Setting Security Policies for JDBC Resources
• Security Roles for JDBC MBeans
  • JDBC Domain Configuration MBeans
  • JDBC System Module MBeans

9 Deploying Data Sources on Servers and Clusters

• Deploying Data Sources on Servers and Clusters
• Minimizing Server Startup Hang Caused By an Unresponsive Database

10 Tuning Data Source Connection Pools

• Increasing Performance with the Statement Cache
  • Statement Cache Algorithms
    • LRU (Least Recently Used)
    • Fixed
  • Statement Cache Size
  • Usage Restrictions for the Statement Cache
    • Calling a Stored Statement After a Database Change May Cause Errors
    • Using setNull In a Prepared Statement
    • Statements in the Cache May Reserve Database Cursors
• Connection Testing Options for a Data Source
  • Database Connection Testing Semantics
    • Connection Testing When Database Connections are Created
    • Periodic Connection Testing
    • Testing Reserved Connections
    • Minimized Connection Test Delay After Database Connectivity Loss
    • Minimized Connection Request Delay After Connection Test Failures
    • Minimized Connection Request Delays After Loss of DBMS Connectivity
    • Minimizing Connection Request Delay with Seconds to Trust an Idle Pool Connection
  • Database Connection Testing Configuration Recommendations
  • Default Test Table Name
• Enabling Connection Creation Retries
• Enabling Connection Requests to Wait for a Connection
  • Connection Reserve Timeout
  • Limiting the Number of Waiting Connection Requests
• Automatically Recovering Leaked Connections
• Avoiding Server Lockup with the Correct Number of Connections
• Limiting Statement Processing Time with Statement Timeout
• Using Pinned-To-Thread Property to Increase Performance
  • Changes to Connection Pool Administration Operations When PinnedToThread is Enabled
  • Additional Database Resource Costs When PinnedToThread is Enabled
• Using Unwrapped Data Type Objects
  • How to Disable Wrapping
    • Disable Wrapping using the Administration Console
    • Disable Wrapping using WLST

11 Using WebLogic Server with Oracle RAC

• Overview of Oracle Real Application Clusters
• Software Requirements
• JDBC Driver Requirements
• Hardware Requirements
  • WebLogic Server Cluster
  • Oracle RAC Cluster
  • Shared Storage
• Configuration Options in WebLogic Server with Oracle RAC
  • Choosing a WebLogic Server Configuration for Use with Oracle RAC
  • Validating Connections when using WebLogic Server with Oracle RAC
  • Additional Considerations When Using WebLogic Server with Oracle RAC

12 Using JDBC Drivers with WebLogic Server

• JDBC Drivers Installed with WebLogic Server
• Setting the Environment for a Type-4 Third-Party JDBC Driver
• Globalization Support for the Oracle 11g Thin Driver
• Using the Oracle Thin Driver in Debug Mode
• Using the Oracle Thin Driver Over SSL

13 Monitoring WebLogic JDBC Resources

• Viewing Run-Time Statistics
  • Data Source Statistics
  • Prepared Statement Cache Statistics
• Collecting Profile Information
  • Profile Types
    • Connection Usage (PROFILE_TYPE_CONN_USAGE_STR)
    • Connection Reservation Wait (PROFILE_TYPE_CONN_RESV_WAIT_STR)
    • Connection Reservation Failed (PROFILE_TYPE_CONN_RESV_FAIL_STR)
    • Connection Leak (PROFILE_TYPE_CONN_LEAK_STR)
    • Connection Last Usage (PROFILE_TYPE_CONN_LAST_USAGE_STR)
    • Connection Multithreaded Usage (PROFILE_TYPE_CONN_MT_USAGE_STR)
    • Statement Cache Entry (PROFILE_TYPE_STMT_CACHE_ENTRY_STR)
    • Statements Usage (PROFILE_TYPE_STMT_USAGE_STR)
  • Accessing Diagnostic Data
  • Callbacks for Monitoring Driver-Level Statistics
• Debugging JDBC Data Sources
  • Enabling Debugging
    • Enable Debugging Using the Command Line
    • Enable Debugging Using the WebLogic Server Administration Console
    • Enable Debugging Using the WebLogic Scripting Tool
    • Changes to the config.xml File
  • JDBC Debugging Scopes
  • Request Dyeing

14 Managing WebLogic JDBC Resources

• Testing Data Sources and Database Connections
• Managing the Statement Cache for a Data Source
  • Clearing the Statement Cache for a Data Source
  • Clearing the Statement Cache for a Single Connection
• Shrinking a Connection Pool
• Resetting a Connection Pool
• Suspending a Connection Pool
• Resuming a Connection Pool
• Shutting Down a Data Source
• Starting a Data Source
• Managing DBMS Network Failures

A Configuring JDBC Application Modules for Deployment

• Packaging a JDBC Module with an Enterprise Application: Main Steps
• Creating Packaged JDBC Modules
  • Creating a JDBC Data Source Module Using the Administration Console
  • JDBC Packaged Module Requirements
  • JDBC Application Module Limitations
  • Creating a JDBC Data Source Module
  • Creating a JDBC Multi Data Source Module
  • Encrypting Database Passwords in a JDBC Module
    • Deploying JDBC Modules to New Domains
  • Application Scoping for a Packaged JDBC Module
• Referencing a JDBC Module in Java EE Descriptor Files
  • Packaged JDBC Module References in weblogic-application.xml
  • Packaged JDBC Module References in Other Descriptors
• Packaging an Enterprise Application with a JDBC Module
• Deploying an Enterprise Application with a JDBC Module
• Getting a Database Connection from a Packaged JDBC Module

B Using Multi Data Sources with Oracle RAC

• Overview of Oracle Real Application Clusters
  • Oracle RAC Scalability with WebLogic Server Multi Data Sources
  • Oracle RAC Availability with WebLogic Server Multi Data Sources
  • Oracle RAC Load Balancing with WebLogic Server Multi Data Sources
• Software Requirements
• JDBC Driver Requirements
• Hardware Requirements
  • WebLogic Server Cluster
  • Oracle RAC Cluster
  • Shared Storage
• Configuring Multi Data Sources with Oracle RAC
  • Choosing a Multi Data Source Configuration for Use with Oracle RAC
  • Configuring Multi Data Sources for use with Oracle RAC
    • Attributes of a Multi Data Source
  • Configuration Considerations for Failover
    • Multi Data Source-Managed Failover and Load Balancing
    • Delays During Failover
    • Failure Handling Walkthrough for Global Transactions
  • Configuring the Listener Process for Each Oracle RAC Instance
  • Configuring Multi Data Sources When Remote Listeners are Enabled or Disabled
  • Additional Configuration Considerations
• Using Multi Data Sources with Global Transactions
  • Rules for Data Sources within a Multi Data Source Using Global Transactions
  • Required Attributes of Data Sources within a Multi Data Source Using Global Transactions
  • Sample Configuration Code
• Using Multi Data Sources without Global Transactions
  • Attributes of Data Sources within a Multi Data Source Not Using Global Transactions
  • Sample Configuration Code
• Configuring Connections to Services on Oracle RAC Nodes
  • Configuring a Data Source to Connect to a Service
  • Service Connection Configurations
    • Workload Management
    • Load Balancing
  • Connection Pool Capacity Planning
• XA Considerations and Limitations when using multi Data Sources with Oracle RAC
  • Oracle RAC XA Requirements when using multi Data Sources
    • Use Multi Data Sources
    • A Global Transaction Must Be Initiated, Prepared, and Concluded in the Same Instance of the Oracle RAC Cluster
    • Transaction IDs Must Be Unique Within the Oracle RAC Cluster
  • Known Limitations When Using Oracle RAC with multi Data Sources
    • Potential for Data Deadlocks in Some Failure Scenarios
    • Potential for Transactions Completed Out of Sequence
  • Known Issue Occurring After Database Server Crash
• JDBC Store Recovery with Oracle RAC
  • Configuring a JDBC Store for Use with Oracle RAC
  • Automatic Retry

C Using Connect-Time Failover with Oracle RAC

• Using Connect-Time Failover without Global Transactions
• Attributes of a Connect-Time Failover Configuration without Global Transactions
• Sample Configuration Code

D Using Fast Connection Failover with Oracle RAC

• JDBC Driver Configuration for use with Oracle Fast Connection Failover