1 Introduction and Roadmap

This section describes the contents and organization of this guide—Administering JDBC Data Sources for Oracle WebLogic Server.

Document Scope and Audience

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.

Guide to this Document

Related Documentation

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:

JDBC Samples and Tutorials

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.

Avitek Medical Records Application (MedRec) and Tutorials

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.

JDBC Examples in the WebLogic Server Distribution

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 Understanding Oracle WebLogic Server.

New and Changed JDBC Data Source Features in This Release

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 12c Driver Support

WebLogic Server 12.1.2.0 is certified to operate with the Oracle 12c database and Oracle 12c JDBC driver. For details, see "Supported Configurations" in What's New in Oracle WebLogic Server.

JDBC 4.1 Support for JDK 7

This release of WebLogic Server supports the JDBC 4.1 Specification when the environment is using JDK 7 and the JDBC driver is JDBC 4.1 compliant. To use new JDBC 4.1 methods with the Oracle thin client, you must use the ojdbc7.jar. If the methods are called for a driver that does not support JDBC 4.1, a java.lang.AbstractMethodError is thrown. See "JDBC™ 4.1 Specification" at http://download.oracle.com/otndocs/jcp/jdbc-4_1-mrel-spec/index.html.

Note:

WebLogic Server currently does not support the java.sql.driver interfaces required to use the Java SE 7 getParrentLogger method. See http://docs.oracle.com/javase/7/docs/api/index.html?java/sql/Driver.html.

JDK 7 also brings support for minor changes in Rowset 1.1 defined at http://jcp.org/aboutJava/communityprocess/maintenance/jsr114/114MR2approved.pdf. The WebLogic Server implementation of the new RowSetFactory is called weblogic.jdbc.rowset.JdbcRowSetFactory.

Application Continuity Support

Application Continuity is an Oracle database feature that provides a general purpose, application-independent infrastructure that enables recovery of work and masks many system, communication, and hardware failures. See Application Continuity.

Database Resident Connection Pooling Support

Database Resident Connection Pooling (DRCP) is an Oracle database server feature that provides the ability to share connections among multiple connection pools that can span across mid-tier systems. See Database Resident Connection Pooling.

Oracle Data Base Testing Using PINGDATABASE

You can improve the connection testing performance of your Oracle data source by setting the Test Table Name attributed of the connection pool to SQL PINGDATABASE. See Oracle Database Connection Testing Using PINGDATABASE.

Global Database Services Support

Global Data Services (GDS) is an Oracle database server feature that provides automated load balancing, fault tolerance and resource utilization in a distributed database environment. See Global Database Services.

Pinned-to-thread Support for Active GridLink Data Sources

This release extends the Pinned-to-Thread feature to an Active GridLink Data Source. Using Pinned-to-Thread can increase performance by minimizing the time it takes for an application to reserve a database connection from a data source and eliminating contention between threads for a database connection. See Using Pinned-To-Thread Property to Increase Performance.

Using Active GridLink Data Sources without Fan Notification

In this release, you can configure and use an Active GridLink data source without enabling Fast Application Notification (FAN). See Using Active GridLink Data Sources without FAN Notification.

Set Identity and/or Client Identifier as WebLogic User

To simplify the configuration of large numbers of users, WebLogic Server provides a data source configuration option that sets the user for Identify based pooling and/or the client identifier directly using the WebLogic Server user, rather than using a credential mapper. See Understanding Data Source Security.

Automatic ONS Listeners

If you are using an Oracle 12c database with WebLogic Server release12.1.2 and higher, you are no longer required to provide the ONS Listener list as part of an Active GridLink data source configuration. The ONS list is automatically provided from the database to the driver. See Enabling FAN Events.

Connection Testing Improvements

This release provides two new connection pool tuning attributes, CountOfTestFailuresTillFlush and CountOfRefreshFailuresTillDisable, that can improve performance in some situations by minimizing the delay caused by testing dead connections. See Connection Testing When Database Connections are Created.

Maintenance Timer Improvements

WebLogic JDBC provides several new timer properties that allow you to tune the performance or your JDBC data sources:

  • weblogic.jdbc.gravitationShrinkFrequencySeconds

  • weblogic.jdbc.harvestingFrequencySeconds

  • weblogic.jdbc.securityCacheTimeoutSeconds

See Tuning Maintenance Timers.

Datasource Configuration Changes

Identity based pooling was previously documented as not supported with pinned-to-thread. It is now flagged as a configuration error that causes a data source to fail to deploy. See Using Pinned-To-Thread Property to Increase Performance.

Java DB Support

This document refers to the Derby database. The references regarding use of the Derby are equally applicable to Java DB. Java DB is Oracle's distribution of the open source Apache Derby Java database. It is distributed as part of the Java Development Kit. See Java DB at http://www.oracle.com/technetwork/java/javadb/overview/index.html.

Edition-based Redefinition

Edition-based Redefinition is an Oracle database feature that enables you to upgrade the database component of an application while it is in use. See Enabling Edition-Based Redefinition.

Container Database with Pluggable Databases

Container Database (CDB) is an Oracle Database feature that minimizes the overhead of having many of databases by consolidating them into a single database with multiple Pluggable Databases (PDB) in a single CDB. See Container Database with Pluggable Databases.

Smart Upgrade Support for JDBC

WebLogic Server SmartUpgrade is an Oracle JDeveloper extension and command-line utility that analyzes the applications previously deployed on Oracle OC4J. It then offers advice and performs actions that can help you successfully redeploy the applications on Oracle WebLogic Server. You can analyze an application archive, or you can analyze an application or project you have opened in Oracle JDeveloper. In addition, SmartUpgrade can analyze the OC4J server where you deployed your applications and provide advice on how to set up a similar configuration in Oracle WebLogic Server. See Smart Upgrade Support for JDBC.

JDBC Related Changes in the WebLogic Server Distribution

Many JDBC files that were located in the wlserver/server/lib directory have moved to the following locations:

The following files have moved to ORACLE_HOME/oracle_common/modules/datadirect:


64sqljdbc.dll
DDJDBC64Auth05.dll
DDJDBCAuth05.dll
DDJDBCx64Auth05.dll
fmwgenerictoken.jar
instjdbc.sql
sqljdbc.dll
wldb2.jar
wlinformix.jar
wlsybase.jar
wlsqlserver.jar
x64sqljdbc.dll

The following files have moved to ORACLE_HOME/oracle_common/modules/oracle.jdbc_11.2.0:


ojdbc6.jar
ojdbc6dms.jar
ojdbc6_g.jar

The following files have moved to ORACLE_HOME/oracle_common/modules/oracle.nlsrtl_11.2.0:


orai18n-mapping.jar
orai18n.jar

The following files have moved to ORACLE_HOME/oracle_common/modules/oracle.ons_12.1.1:


ons.jar

The following files have moved to ORACLE_HOME/oracle_common/modules :


oracle.ucp_11.2.0.jar