This chapter includes the following sections:
This document is a resource for software developers and system administrators who develop and support applications that use the Java Database Connectivity (JDBC) API. It also contains information that is useful for business analysts and system architects who are evaluating WebLogic Server. The topics in this document are relevant during the evaluation, design, development, pre-production, and production phases of a software project.
This document does not address specific JDBC programming topics. For links to WebLogic Server documentation and resources for this topic, see Related Documentation.
It is assumed that the reader is familiar with Java EE and JDBC concepts. This document emphasizes the value-added features provided by WebLogic Server.
This chapter, Introduction and Roadmap, introduces the organization of this guide and lists new features in the current release.
Configuring WebLogic JDBC Resources, provides an overview of WebLogic JDBC resources.
Configuring JDBC Data Sources, describes WebLogic JDBC data source configuration.
Configuring JDBC Multi Data Sources, describes WebLogic JDBC multi data source configuration.
Using Active GridLink Data Sources, describes WebLogic Active GridLink Data Source configuration.
Advanced Configurations for Oracle Drivers and Databases, provides advanced configuration options that can provide improved data source and driver performance when using Oracle drivers and databases.
Connection Harvesting, describes how to configure and use connection harvesting in your applications.
Labeling Connections , provides information on how to label connections to increase performance.
JDBC Data Source Transaction Options, provides information on XA, non-XA, and Global Transaction options for WebLogic data sources.
Understanding Data Source Security, provides information on how WebLogic Server uses configuration options to secure JDBC data sources.
Creating and Managing Oracle Wallet, provides information on how to create and manage an Oracle Wallet to store database credentials for WebLogic Server datasource definitions.
Deploying Data Sources on Servers and Clusters, provides information on how to deploy data sources on servers and clusters.
Using WebLogic Server with Oracle RAC, describes how to configure WebLogic Server for use with Oracle Real Application Clusters.
Using JDBC Drivers with WebLogic Server, describes how to use JDBC drivers from other sources in your WebLogic JDBC data source configuration.
Monitoring WebLogic JDBC Resources, describes how to monitor JDBC resources, gather profile information about database connection usage, and enable JDBC debugging.
Managing WebLogic JDBC Resources, describes how to administer data sources.
Tuning Data Source Connection Pools, provides information on how to properly tune the connection pool attributes in JDBC data sources in your WebLogic Server domain to improve application and system performance.
Using an Oracle 12c Database, provides information on how to configure WebLogic Server Release 12.1.2 and higher to interoperate with an Oracle 12c database.
Configuring JDBC Application Modules for Deployment, describes how to package a WebLogic JDBC module with your enterprise application.
Using Multi Data Sources with Oracle RAC, describes how to configure multi data sources for use with Oracle Real Application Clusters.
Using Fast Connection Failover with Oracle RAC, describes how to use WebLogic server with Oracle Fast Connection Failover.
This document contains JDBC data source configuration and administration information.
For comprehensive guidelines for developing, deploying, and monitoring WebLogic Server applications, see the following documents:
Developing JDBC Applications for Oracle WebLogic Server is a guide to JDBC API programming with WebLogic Server.
Developing Applications for Oracle WebLogic Server is a guide to developing WebLogic Server applications.
Deploying Applications to Oracle WebLogic Server is the primary source of information about deploying WebLogic Server applications in development and production environments.
In addition to this document, Oracle provides a variety of JDBC code samples and tutorials that show configuration and API use, and provide practical instructions on how to perform key JDBC development tasks.
MedRec is an end-to-end sample Java EE application shipped with WebLogic Server that simulates an independent, centralized medical record management system. The MedRec application provides a framework for patients, doctors, and administrators to manage patient data using a variety of different clients.
MedRec demonstrates WebLogic Server and Java EE features, and highlights Oracle-recommended best practices. MedRec is optionally installed with the WebLogic Server installation. You can start MedRec from the ORACLE_HOME\user_projects\domains\medrec directory, where ORACLE_HOME is the directory you specified as the Oracle Home when you installed Oracle WebLogic Server.
WebLogic Server optionally installs API code examples in EXAMPLES_HOME\wl_server\examples\src\examples, where EXAMPLES_HOME represents the directory in which the WebLogic Server code examples are configured. For more information, see "Sample Applications and Code Examples" in Introduction to Oracle WebLogic Server.
This release includes the following new and changed features:
For a comprehensive listing of the new WebLogic Server features introduced in this release, see What's New in Oracle WebLogic Server.
Oracle provides Default Data Source support required by a Java EE 7-compliant runtime. This includes a configured data source that can be used by an application to access the Derby Database installed with WebLogic Server. See Using the Default Data Source
In previous releases, adding a new JDBC driver or updating a JDBC driver where the replacement JAR has a different name than the original JAR required updating the WebLogic Server's classpath to include the location of the JDBC driver classes. In this release, you can simply put the drivers in the $DOMAIN_HOME/lib directory and not have to change the classpath. See Adding Third-Party JDBC Drivers Not Installed with WebLogic Server
Oracle provides a new data source type which provides the ability to switch between databases in a WebLogic Server Java EE Multitenant environment. See Using Proxy Data Sources
A UCP data source is provided as an option for users who wish to use Oracle Universal Connection Pooling (UCP) to connect to Oracle Databases. UCP provides an alternative connection pooling technology to Oracle WebLogic Server connection pooling. For more information, see Using Universal Connection Pool Data Sources
Data source configuration and monitoring support for WebLogic Server Multitenant. See "Configuring JDBC" in Using WebLogic Server Multitenant.
Connection leak profiling enhancements include:
A new attribute, Set Connection Leak Timeout Seconds, that can be used instead of Inactive Connection Timeout Seconds to specify the length of time before a reserved connection is considered leaked.
Two new profile records:
JDBC Object Closed Usage—Collect profile information about application components that close a connection, statement, or result set.
Local Transaction Connection Leak—Collect profile information about application components that leak a local transaction (start it but don't commit or rollback the transaction).
For more information, see Collecting Profile Information in Administering JDBC Data Sources for Oracle WebLogic Server.
You can set connection-based system properties using variables based on your environment. For more information, see Enabling Connection-based System Properties
Application Continuity (or Replay) statistics are available using the JDBCReplayStatisticsRuntimeMBean for Generic and Active GridLink data sources. For more information, see Viewing Runtime Statistics for Application Continuity
You can now use a property node list to configure the ONS node list. The property node list, which can be used instead of a single node list, is a string composed of multiple records, with each record consisting of a key=value pair. For more information, see ONS Client Configuration
In this release, a system property weblogic.jdbc.attachNetworkTimeout is provided that, after an attach to the server, specifies a network timeout that forces a round-trip to the database (using an Oracle ping database operation). The timeout is then unset. For more information, see Database Resident Connection Pooling
The documentation that describes this feature has been enhanced to include details about using EBR with JDBC connections, and describes how to configure WebLogic data sources to use Editions. For more information, see Using Edition-Based Redefinition
(Procedures and guidelines have been included for planning and managing database maintenance and downtimes for Multi Data Source and Active Gridlink data sources. For more information, see the following topics: