This chapter provides information on how to configure and use WebLogic Server Release 12.1.2 with an Oracle 12c database.
WebLogic Server Release 12.1.2 provides several new features that specifically require the use of an Oracle 12c database and Oracle 12c JDBC driver. The following section provide information on how to update your environment to use an Oracle 12c Database and Oracle 12c JDBC driver:
This section lists the files required to use an Oracle 12c driver with WebLogic Server 12.1.2. All file locations are provided relative to ORACLE_HOME in your WebLogic Server distribution. Files must be used in a matched set.
Select one of the following ojdbc files:
jdbc/lib/ojdbc7.jar
jdbc/lib/ojdbc7_g.jar
jdbc/lib/ojdbc7dms.jar
jdbc/lib/ojdbc6.jar
jdbc/lib/ojdbc6_g.jar
jdbc/lib/ojdbc6dms.jar
The following table lists additional required driver files:
Table A-1 Additional 12c Driver Files
| File | Description |
|---|---|
|
|
Universal Connection Pool |
|
|
Oracle Network Server client |
|
|
I18N support |
|
|
I18N support |
|
|
Oracle Wallet support |
|
|
Oracle Wallet support |
|
|
Oracle Wallet support |
The following table lists additional files for SQL XML support:
The 12c Oracle database jar files are not shipped with this version of WebLogic Server. Oracle recommends that you download and install a 12c Oracle Client kit – either the Runtime or Administrator package from the Download tab at http://www.oracle.com/technetwork/index.html.
To use an Oracle 12c database and Oracle 12c JDBC driver, you must update the CLASSPATH in your WebLogic Server environment. Prepend the required files specified in Required Oracle 12c Driver Files to the CLASSPATH (before the 11.2.0.3 Driver jar files).
The following code sample outlines a simple Linux batch file that updates the CLASSPATH of your WebLogic environment. Make sure ORACLE_HOME is set appropriately. This example assumes the SEP variable is set to the correct CLASSPATH separator (";" or ":") for your platform.
# pick one of the ojdbc jar files
CLASSPATH="${ORACLE_HOME}/jdbc/lib/ojdbc7.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/ucp/lib/ucp.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/opmn/lib/ons.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/jlib/orai18n.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/jlib/orai18n-mapping.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/jlib/oraclepki.jar ${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/jlib/osdt_cert.jar ${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/jlib/osdt_core.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/ RDBMS/jlib/xdb.jar ${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/LIB/xmlparserv2_sans_jaxp_services.jar${SEP}$CLASSPATH"
CLASSPATH="${ORACLE_HOME}/ jlib/orai18n-collation.jar${SEP}$CLASSPATH"
For a DOS batch file, change each line to use the following syntax:
set CLASSPATH=%ORACLE_HOME%\jdbc\lib\ojdbc7.jar%SEP%%CLASSPATH%
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 https://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 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 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 release12.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-3 Summary of 12c Database Feature Support with WebLogic Server
| Feature | WebLogic Server 10.3.6/12.1.1/12.1.2 with 11g drivers and 11gR2 DB | WebLogic Server 10.3.6/12.1.1/12.1.2 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 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 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 |
|
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 |