|Oracle® Fusion Middleware Programming JDBC for Oracle WebLogic Server
12c Release 1 (12.1.1)
Part Number E24376-03
|PDF · Mobi · ePub|
This chapter provides information about the WebLogic-branded DataDirect drivers that are included in the WebLogic Server installation.
Oracle provides WebLogic-branded versions of DataDirect drivers for DB2, Informix, MS SQL Server, and Sybase. Review the following sections for information on how WebLogic-branded DataDirect drivers are configured and used in a WebLogic Server environment. For detailed information on these drivers, see "Progress DataDirect for JDBC User's Guide Release 4.2" and "Progress DataDirect for JDBC Reference Release 4.2" at
http://www.datadirect.com/index.html. You will need to make the following adaptations where appropriate when using DataDirect documentation:
URLs: substitute "weblogic" for "datadirect"
Install directory: the fully qualified installation directory for WebLogic-branded DataDirect drivers is
WebLogic-branded Data Direct drivers are compliant with the JDBC 4.0 specification.
When comparing WebLogic Server behavior when using drivers from different vendors, it is important to remember that even though the drivers are JDBC specification compliant, a vendor may interpret the specification differently or provide different implementations for a given situation.
For example: When using the WebLogic-branded SQL Server driver, if you enter a negative value (-100) into a
TINYINT column where the schema defines the range as 0 to 256, the driver throws an exception, whereas the Microsoft SQL Server driver ignores the minus sign.
WebLogic-branded DataDirect drivers are installed with WebLogic Server in the
\server\lib folder, where WL_HOME is the directory in which you installed WebLogic Server. Driver class files are included in the manifest classpath in
weblogic.jar, so the drivers are automatically added to your classpath on the server.
WebLogic-branded DataDirect drivers are installed by default when you perform a complete installation of WebLogic Server. If you choose a custom installation, ensure that the WebLogic JDBC Drivers option is selected (checked). If this option is unchecked, the drivers are not installed.
WebLogic-branded DataDirect drivers are not included in the manifest classpath of the WebLogic client jar files (for example:
wlclient.jar). To use the drivers with a WebLogic client, you must copy the following files to the client and add them to the classpath on the client:
For MS SQL Server:
For information on driver and database support, see
Create a JDBC data source in your WebLogic Server configuration and select the JDBC driver to create the physical database connections in the data source. Applications can then look up the data source on the JNDI tree and request a connection.
See the following related information:
For information about JDBC and data sources in WebLogic Server, see Configuring and Managing JDBC Data Sources for Oracle WebLogic Server.
For information about requesting a connection from a data source, see "Obtaining a Client Connection Using a DataSource" in Programming JDBC for Oracle WebLogic Server.
You can develop and use your own JDBC code that uses WebLogic-branded DataDirect drivers as long as the code is executed in a WebLogic Server classpath/environment.
You specify connection properties for connections in a data source using the WebLogic Server Administration Console, command line interface, or JMX API. Connection properties vary by DBMS. For the list of the connection properties specific to each of the WebLogic-branded DataDirect drivers, see the "Connection Properties" section for your driver in "Progress DataDirect for JDBC User's Guide".
WebLogic-branded DataDirect drivers support Internet Protocol (IP) addresses in IPv4 and IPv6 format as described in "Progress DataDirect for JDBC User's Guide Release 4.2" at
http://www.datadirect.com/index.html. In a WebLogic environment, simply convert the
jdbc:datadirect portion of the URL to
jdbc:weblogic. For example, the following connection URL specifies the server using IPv4 format:
Using WebLogic-branded DataDirect drivers with the Java Security Manager enabled requires certain permissions to be set in the security policy file of the domain. WebLogic Server provides a sample security policy file that you can edit and use. The file is located at
weblogic.policy file includes all necessary permissions for the drivers.
If you use the
weblogic.policy file without changes, you may not need to grant any further permissions. If you use another security policy file or if you use driver features that require additional permissions, see the "Progress DataDirect for JDBC User's Guide Release 4.2" at
/server as the
WL_HOME is the directory in which you installed WebLogic Server.
For more information about using the Java Security Manager with WebLogic Server, see "Using Java Security to Protect WebLogic Resources" in Programming Security for Oracle WebLogic Server.
This section provides additional information on configuring MS SQLServer for use with DataDirect MS SQL Server driver:
WebLogic Server provides the following XA dlls for MS SQL Server:
sqljdbc.dll: for 32-bit Windows
64sqljdbc.dll: for 64-bit Windows
X64sqljdbc.dll: for the X64 processors
To install, do the following:
cd to the
32-bit Windows systems, install the
64-bit Windows systems, copy the
64sqljdbc.dll file, rename as
sqljdbc.dll, and then install the
X64 processors, copy the
X64sqljdbc.dll file, rename as
sqljdbc.dll, and then install the
There is a known error in some versions of the DataDirect
instjdbc.sql script that installs stored procedures into MS SQLServer versions 2008 and newer. The workaround is to replace all instances of
dump tran master with no_log in the
instjdbc.sql script with
DBCC SHRINKFILE(mastlog, 1).