Configuring and Managing WebLogic JDBC
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.
This document does not address specific JDBC programming topics. For links to WebLogic Server documentation and resources for this topic, see Related Documentation.
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.1 optionally installs API code examples in
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.1 Start menu.
Additional API examples for download at http://codesamples.projects.dev2dev.bea.com. These examples are distributed as ZIP files that you can unzip into an existing WebLogic Server samples directory structure.
You build and run the downloadable examples in the same manner as you would an installed WebLogic Server example. See the download pages of individual examples for more information at
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.
For detailed information on changes to supported drivers, see WebLogic Type 4 JDBC Drivers.
This feature provides identity-based-connection-pooling for a data source. When an application requests a database connection, the WebLogic Server instance picks or creates a physical connection with requested DBMS identity based on a map of WebLogic user IDs and database IDs.
For more information, see Identity-based Connection Pooling.
This feature provides support for the Sybase JConnect 6.0 (JDBC 2.0) driver. This third-party JDBC driver is installed with WebLogic Server. See "Using Third-Party JDBC Drivers with WebLogic Server" in Configuring and Managing WebLogic JDBC.