Table of Contents
- Title and Copyright Information
- Preface
- 1 About WebLogic JDBC Resources
- 2 Configuring WebLogic JDBC Resources
-
3
Configure Database Connectivity
-
Using JDBC Drivers with WebLogic Server
- Types of JDBC Drivers
- JDBC Driver Support
- JDBC Drivers Installed with WebLogic Server
- Upgrading and Using Latest Oracle 19c JDBC Drivers with WebLogic Server
- Adding Third-Party JDBC Drivers Not Installed with WebLogic Server
- Globalization Support for the Oracle Thin Driver
- Using the Oracle Thin Driver in Debug Mode
-
Configuring JDBC Data Sources
- Creating a JDBC Data Source
- Configuring Connection Pool Features
- Advanced Connection Properties
- Configure Oracle Parameters
- Configure ONS Client Parameters
- Tuning Generic Data Source Connection Pools
- Generic Data Source Handling for Oracle RAC Outages
- Generic Data Source Handling of Driver-Level Failover
-
Using JDBC Drivers with WebLogic Server
-
4
JDBC Data Sources Types
- Using the Default Data Source
- Using Generic Data Sources
-
Using JDBC Multi Data Sources
- What is Multi Data Source
- Configuring Multi Data Sources
- Multi Data Source Failover Enhancements
- Planned Database Maintenance with a Multi Data Source
- Shutting Down the Data Source
-
Using Active GridLink Data Sources
- What is Active GridLink Data Source
- Configuring Active GridLink Data Source
- Configuring Runtime Load Balancing using SDP
- Configuring Active GridLink Connection Pool Features
- Tuning Active GridLink Data Source Connection Pools
- Monitoring Active GridLink JDBC Resources
- Using Active GridLink Data Sources without FAN Notification
- Best Practices for Active GridLink Data Sources
- Comparing Active GridLink and Multi Data Sources
- Migrating from Multi Data Source to Active GridLink
- Managing Database Downtime with Active GridLink Data Sources
- Gradual Draining
- Using Universal Connection Pool Data Sources
- Using Proxy Data Sources
- 5 JDBC Data Source Transaction Options
-
6
Advanced Configurations for Oracle Drivers and Databases
-
JDBC Replay Driver
- How JDBC Replay Driver Works
- Requirements and Considerations
- Configuring JDBC Replay Driver
- Viewing Runtime Statistics for JDBC Replay Driver
- JDBC Replay Driver Auditing
- Limitations with JDBC Replay Driver with Oracle 12c Database
- Database Resident Connection Pooling
- Global Data Services
- Container Database with Pluggable Databases
- Service Switching
-
JDBC Replay Driver
- 7 Using Connection Harvesting
- 8 Using Shared Pooling Data Sources
- 9 Using Oracle Databases with WebLogic Server
-
10
Labeling Connections
- What is Connection Labeling
- Implementing Labeling Callbacks
- Creating a Labeling Callback
- Registering a Labeling Callback
- Reserving Labeled Connections
- Checking Unmatched labels
- Removing a Connection Label
- Using Initialization and Reinitialization Costs to Select Connections
- Using Connection Labeling with Packaged Applications
- 11 Understanding Data Source Security
- 12 Creating and Managing Oracle Wallet
- 13 Deploying Data Sources on Servers and Clusters
- 14 Using WebLogic Server with Oracle RAC
-
15
Monitoring WebLogic JDBC Resources
- Viewing Run-Time Statistics
- Profile Logging
-
Collecting Profile Information
-
Profile Types
- Connection Usage (WEBLOGIC.JDBC.CONN.USAGE)
- Connection Reservation Wait (WEBLOGIC.JDBC.CONN.RESV.WAIT)
- Connection Reservation Failed (WEBLOGIC.JDBC.CONN.RESV.FAIL)
- Connection Leak (WEBLOGIC.JDBC.CONN.LEAK)
- Connection Last Usage (WEBLOGIC.JDBC.CONN.LAST_USAGE)
- Connection Multithreaded Usage (WEBLOGIC.JDBC.CONN.MT_USAGE)
- Statement Cache Entry (WEBLOGIC.JDBC.STMT_CACHE.ENTRY)
- Statements Usage (WEBLOGIC.JDBC.STMT.USAGE)
- Connection Unwrap (WEBLOGIC.JDBC.CONN.UNWRAP)
- JDBC Object Closed Usage (WEBLOGIC.JDBC.CLOSED_USAGE)
- Local Transaction Connection Leak (WEBLOGIC.JDBC.CONN.LOCALTX_LEAK)
- Example Profile Information Record Log
- Accessing Diagnostic Data
- Callbacks for Monitoring Driver-Level Statistics
-
Profile Types
- Debugging JDBC Data Sources
- 16 Managing WebLogic JDBC Resources
-
17
Tuning Data Source Connection Pools
- Increasing Performance with the Statement Cache
- Initial Capacity Enhancement in the Connection Pool
-
Connection Testing Options for a Data Source
-
Database Connection Testing Semantics
- Connection Testing When Database Connections are Created
- Periodic Connection Testing
- Testing Reserved Connections
- Minimizing Connection Test Delay After Database Connectivity Loss
- Minimizing 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
- Database Connection Testing Using Default Test Table Name
- Database Connection Testing Options
-
Database Connection Testing Semantics
- Enabling Connection Creation Retries
- Enabling Connection Requests to Wait for a Connection
- 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
- Using Unwrapped Data Type Objects
- Tuning Maintenance Timers
- JDBC Connection Creation Limits
-
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 Generic Data Source Module
- Creating an Active GridLink Data Source Module
- Creating a Multi Data Source Module
- Encrypting Database Passwords in a JDBC Module
- Application Scoping for a Packaged JDBC Module
- Referencing a JDBC Module in Java EE Descriptor Files
- 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 RAC
- Software Requirements
- JDBC Driver Requirements
- Hardware Requirements
-
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
- Configuration Considerations for Failover
- 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
- Using Multi Data Sources without Global Transactions
- Configuring Connections to Services on Oracle RAC Nodes
- Using SCAN Addresses with Multi Data Sources
- XA Considerations and Limitations when using Multi Data Sources with Oracle RAC
- JDBC Store Recovery with Oracle RAC