WebLogic Type 4 JDBC Drivers
This section describes the contents and organization of this guide—WebLogic Server Type 4 JDBC Drivers.
This document is a resource for software developers and system administrators who develop and support applications that use the Java Database Connectivity (JDBC) API. It also contains information that is useful for business analysts and system architects who are evaluating WebLogic Server. The topics in this document are relevant during the evaluation, design, development, pre-production, and production phases of a software project.
It is assumed that the reader is familiar with J2EE and EJB concepts. This document emphasizes the value-added features provided by WebLogic Server EJBs and key information about how to use WebLogic Server features and facilities to get an EJB application up and running.
This document contains JDBC-specific driver information.
For comprehensive guidelines for developing, deploying, and monitoring WebLogic Server applications, see the following documents:
In addition to this document, BEA Systems provides a variety of JDBC code samples and tutorials that show JDBC configuration and API use, and provide practical instructions on how to perform key JDBC development tasks.
MedRec is an end-to-end sample J2EE application shipped with WebLogic Server that simulates an independent, centralized medical record management system. The MedRec application provides a framework for patients, doctors, and administrators to manage patient data using a variety of different clients.
MedRec demonstrates WebLogic Server and J2EE features, and highlights BEA-recommended best practices. MedRec is included in the WebLogic Server distribution, and can be accessed from the Start menu on Windows machines. For Linux and other platforms, you can start MedRec from the WL_HOME\samples\domains\medrec
directory, where WL_HOME
is the top-level installation directory for WebLogic Platform.
WebLogic Server 9.0 optionally installs API code examples in WL_HOME\samples\server\examples\src\examples
, where WL_HOME
is the top-level directory of your WebLogic Server installation. You can start the examples server, and obtain information about the samples and how to run them from the WebLogic Server 9.0 Start menu.
The following sections describe new features and changes for WebLogic Server Type 4 JDBC Drivers in WebLogic Server 9.1:
For a comprehensive listing of the new WebLogic JDBC features introduced in release 9.1, see "What's New in WebLogic Server 9.1" in Release Notes.
Note: If you are not familiar with the new features provided in version 9.0 of WebLogic Server, see the What's New in WebLogic Server 9.0 section of the WebLogic Server Release Notes.
ResultSet
metadata support.JavaDoubleToString
connection option allows you to choose the optimal conversion algorithm when converting double or float values to string values.ResultSetMetaDataOptions
connection option allows the driver to return table name information in ResultSet
metadata for Select
statements.For more information, refer to the documentation for each driver.
For detailed information on these features, see The DB2 Driver.
DBDate
connection option sets the Informix DBDate server environment variable.For detailed information on these features, see The Informix Driver.
EnableCancelTimeout
connection option provides the ability to time out cancel requests.SendFloatParametersAsString
connection option allows the driver to send float and double parameters to the server as a string or floating point number.WireProtocolMode
connection option allows the driver to optimize network traffic to the Oracle server for result sets. Oracle 10g database users may need to set WireProtocolMode=2
to prevent performance degradation when using parameterized queries (prepared and callable statements) involving big tables. See Oracle Connection Properties.For detailed information on these features, see The Oracle Driver.
PacketSize
connection option allows you to fine-tune the size of the packet the driver uses to communicate with the database server.EnableCancelTimeout
connection option that provides the ability to time out cancel requests.For detailed information on these features, see The MS SQL Server Driver.
EnableCancelTimeout
connection option that provides the ability to time out cancel requests.UseAlternateProductInfo
connection option allows you to specify whether the driver will perform additional processing to return more accurate information for the DatabaseMetaData.getDatabaseProductName()
and DatabaseMetaData.getDatabaseProductVersion()
methods. ErrorBehavior
connection option allows you to fine-tune how errors that are returned from Stored Procedures are handled.For detailed information on these features, see The Sybase Driver.