Fusion Middleware Documentation
Advanced Search


Administering JDBC Data Sources for Oracle WebLogic Server
Close Window

Table of Contents

Show All | Collapse

A Using an Oracle 12c Database

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:

Required Oracle 12c Driver Files

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

ucp/lib/ucp.jar

Universal Connection Pool

opmn/lib/ons.jar

Oracle Network Server client

jlib/orai18n.jar

I18N support

jlib/orai18n-mapping.jar

I18N support

jlib/oraclepki.jar

Oracle Wallet support

jlib/osdt_cert.jar

Oracle Wallet support

jlib/osdt_core.jar

Oracle Wallet support


The following table lists additional files for SQL XML support:

Table A-2 Additional Files for SQL XML Support

File Description

RDBMS/jlib/xdb.jarucp/lib/ucp.jar

SQLXML support

LIB/xmlparserv2_sans_jaxp_services.jar

SQLXML support

jlib/orai18n-collation.jar

SQLXML support


Download Oracle 12c Database Files

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.

Update the WebLogic Server CLASSPATH

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%

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 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.

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 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.

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-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 Set Container)

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