A Using an Oracle 12c Database

This appendix provides information on how use WebLogic Server Release 12.1.2 and higher with an Oracle 12c database. Oracle provides several new features that specifically require the use of an Oracle 12c database and Oracle 12c JDBC driver.

This appendix includes the following sections:

WebLogic JDBC Features for Oracle 12c Database

The following section provides a list of WebLogic JDBC features for Oracle 12c Database:

JDBC 4.1 Support for JDK 7

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, you must use the ojdbc7.jar. 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 getParentLogger 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.

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.

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.

Automatic ONS Listeners

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

Summary of 12C Database Feature Support with WebLogic Server

This section provides information on how Oracle 12c database features are supported in WebLogic Server releases.

Table A-1 Summary of 12c Database Feature Support with WebLogic Server

Feature WebLogic Server 10.3.6/12.1.x with 11g drivers and 11gR2 DB WebLogic Server 10.3.6/12.1.x with 11g drivers and 12c DB WebLogic Server 10.3.6/12.1.1 with 12c drivers and 11gR2 DB WebLogic Server 12.1.2 and higher with 12c drivers and 11gR2 DB WebLogic Server 10.3.6/12.1.1 with 12c drivers and 12c DB WebLogic Server 12.1.2 and higher with 12c drivers with 12c DB

JDBC replay (read/write)

No

No

No

No

Yes (Read/Write with Active GridLink only, no XA transactions)

Yes (Read/Write with Active GridLink and generic data source, no XA transactions)

Pluggable Database (PDB)

No

Yes (Except Set Container)

No

No

Yes

Yes

Dynamic switching between PDBs

No

No

No

No

No

Yes (no XA)

Database Resident Connection pooling (DRCP)

No

No

No

Yes

No

Yes

Oracle Notification Service (ONS) auto configuration

No

No

No

No

No

Yes (Active GridLink only)

Global Database Services (GDS)

No

Yes (Active GridLink only)

No

No

Yes (Active GridLink only)

Yes (Active GridLink only)

JDBC 4.1 (using ojdbc7.jar files & JDK 7)

No

No

Yes

Yes

Yes

Yes