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:
The following section provides a list of WebLogic JDBC features for Oracle 12c Database:
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 thejava.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 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 (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 (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 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.
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.
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 |
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 |