![](/uploads/1/2/7/6/127652701/290332924.jpg)
From thisThe JDBC driver is typically located at the location WLHOME/server/lib of the installation directory. The file is ojdbc7.jar or ojdbc6.jar (for new versions of WLS), or ojdbc14.jar (for older versions of WLS).One way to check the JDBC driver version is to open the ojdbc jar file and go inside the META-INF folder, and then open the 'MANIFEST.MF' file. The version can be seen next to 'Specification-Version'.Another way is to run the command below on the location mentioned previously:java -jar ojdbc6.jar -getversionNote that you must use the JDBC JAR file intended for the version of the JDK that you are running. For example, 'ojdbc5.jar' is intended for use with JDK 1.5. So if you run JDK 1.5 with the JDBC driver JAR file 'ojdbc6.jar' then a 'java.lang.UnsupportedClassVersionError: Bad version number in.class file' error message will be thrown when performing this check.
Here you can download the dependencies for the java class oracle.jdbc.driver.OracleDriver. Use this engine to looking through the maven repository. 19 Globalization Support. The Oracle Java Database Connectivity (JDBC) drivers provide globalization support, formerly known as National Language Support (NLS). Globalization support enables you retrieve data or insert data into a database in any character set that Oracle supports. If the clients and the server use different character sets, then the driver provides the support to perform the.
WebLogic Server works with JDBC drivers that offer the following functionality:
- Are thread-safe
- Can implement transactions using standard JDBC statements
JDBC drivers that do not implement Serializable or Remote interfaces cannot pass objects to a remote client application.
This section describes how to set up and use JDBC drivers with WebLogic Server. It includes the following sections:
JDBC Drivers Installed with WebLogic Server
The 11g version of the Oracle Thin driver (
ojdbc6.jar
for JDK 6, and ojdbc5.jar
for JDK 5) is installed with Oracle WebLogic Server.Note:
The WebLogic Type 4 JDBC drivers from DataDirect are also installed with WebLogic Server. See Oracle Fusion Middleware Type 4 JDBC Drivers for Oracle WebLogic Server for more information.In addition to the Oracle Thin Driver, the mySQL 5.0.x (mysql-connector-java-commercial-5.0.x-bin.jar) JDBC driver is installed with WebLogic Server.
This driver is installed in the
WL_HOME
serverlib
folder (where WL_HOME
is the folder where WebLogic Server is installed) with weblogic.jar
. The manifest in weblogic.jar
lists this file so that it is loaded when weblogic.jar
is loaded (when the server starts). Therefore, you do not need to add this JDBC driver to your CLASSPATH
. If you plan to use a third-party JDBC driver that is not installed with WebLogic Server, you must install the drivers, which includes updating your CLASSPATH
with the path to the driver files, and may include updating your PATH
with the path to database client files. See 'Supported Database Configurations' on the Oracle Fusion Middleware Supported System Configurations page at http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html
.If you plan to use a different version of any of the drivers installed with WebLogic Server, you can replace the driver file in
WL_HOME
serverlib
with an updated version of the file or add the new file to the front of your CLASSPATH
.Copies of the MySQL and Oracle Thin drivers installed with WebLogic Server and other supporting files are installed in
WL_HOME
serverextjdbc
. There is a subdirectory in this folder for each DBMS. If you need to revert to the version of the driver installed with WebLogic Server, you can copy the file from WL_HOME
serverextjdbcDBMS
to WL_HOME
serverlib
.Note:
![Oracle Oracle](/uploads/1/2/7/6/127652701/315569626.jpg)
WL_HOME
commonevalpointbase
directory. PointBase Server is an all-Java DBMS product included in the WebLogic Server distribution solely in support of WebLogic Server evaluation, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Server. Non-evaluation development or production use of the PointBase Server requires a separate license be obtained by the end user directly from PointBase at http://www.pointbase.com.Setting the Environment for a Type-4 Third-Party JDBC Driver
If you plan to use a third-party JDBC driver that is not installed with WebLogic Server, you need to update the WebLogic Server's classpath to include the location of the JDBC driver classes. Edit the
commEnv.cmd/sh
script in WL_HOME
/common/bin
and prepend your classes as described in 'Modifying the Classpath' in the Oracle Fusion Middleware Command Reference for Oracle WebLogic Server.Globalization Support for the Oracle 11g Thin Driver
For Globalization Support with the 11g version of the Oracle Thin driver, Oracle supplies the
orai18n.jar
file, which replaces nls_charset.zip
. If you use character sets other than US7ASCII, WE8DEC, WE8ISO8859P1 and UTF8 with CHAR and NCHAR data in Oracle object types and collections, you must include orai18n.jar
and orai18n-mapping.jar
in your CLASSPATH
.The
orai18n.jar
and orai18n-mapping.jar
are included with the WebLogic Server installation in the WL_HOME
serverextjdbcoracle11g
folder. These files are not referenced by the weblogic.jar manifest
file, so you must add them to your CLASSPATH
before they can be used.Using the Oracle Thin Driver in Debug Mode
The
WL_HOME
serverextjdbcoracle11g
folder includes the ojdbc6_g.jar
(for JDK 6) and ojdbc5_g.jar
(for JDK 5) files, which are the versions of the Oracle Thin driver with classes to support debugging and tracing. To use the Oracle Thin driver in debug mode, add the path to these files at the beginning of your CLASSPATH
.Using the Oracle Thin Driver Over SSL
This section describes how to configure the data source in WebLogic Server when using the Oracle Thin driver over SSL.
To configure the data source in WebLogic Server, perform the following steps.
- In the Administration Console navigation pane, click the plus sign to expand Services.
- Click the plus sign to expand JDBC.
- Select Data Sources.
- On the Summary of JDBC Data Sources page, select New.
- On the Create a New JDBC Data Source page, provide a JDBC data source name and, optionally, the JNDI name.Select Oracle as the database type, and the Oracle database driver (Thin XA or Thin) you want to use.
- Click Next.
- Select the transaction options, if any. Click Next.
- On the Connection Properties page, enter the Database Name, the Host Name, the Port, and the Database User Name and password. These values are used to construct a URL for the data source. You will modify this URL on the next page, but you need to enter values now to proceed. Click Next.
- On the Test Configuration page, make the following changes:
- Verify that the driver Class Name is oracle.jdbc.xa.client.OracleXADataSource or oracle.jdbc.OracleDriver.
- Modify the URL to use the following syntax and format:(SECURITY=(SSL_SERVER_CERT_DN='CN=<.....>')) is optional and is used only for server DN matching.
- Enter the following properties:javax.net.ssl.keyStore, javax.net.ssl.keyStoreType, and javax.net.ssl.keyStorePassword are needed only if the listener.ora and sqlnet.ora in the database are set to have SSL_CLIENT_AUTHENTICATION=TRUE for two-way SSL.oracle.net.ssl_server_dn_match needs to be set only if server DN matching is needed.
- Enter (or accept) the Test Table Name.
- Optionally, click Test Configuration to test the configuration.
- Click Finish.
![](/uploads/1/2/7/6/127652701/290332924.jpg)