Type 4 JDBC Drivers

Introduction and Roadmap

This section describes the contents and organization of this guide—WebLogic Server Type 4 JDBC Drivers.

• Document Scope and Audience

• Guide to this Document

• Related Documentation

• JDBC Samples and Tutorials

• New and Changed JDBC Features in This Release

 

---

Document Scope and Audience

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

 

---

Guide to this Document

• This chapter, Introduction and Roadmap,,” introduces the organization of this guide.

• Using WebLogic Type 4 JDBC Drivers, provides information about connecting to a database with WebLogic Type 4 JDBC drivers.

• The DB2 Driver, provides detailed information about the DB2 driver.

• The Informix Driver,provides detailed information about the Informix driver.

• The MS SQL Server Driver, provides detailed information about the Microsoft SQL Server driver.

• The Oracle Driver (Deprecated), provides detailed information about the Oracle driver.

• The Sybase Driver, provides detailed information about the Sybase driver.

• JDBC Support lists support for standard and extension JDBC methods.

• GetTypeInfo, provides results returned from the method DataBaseMetaData.getTypeinfo for all of the WebLogic Type 4 JDBC drivers.

• SQL Escape Sequences for JDBC, describes the scalar functions supported for the WebLogic Type 4 JDBC drivers. Your data store may not support all of these functions.

• Tracking JDBC Calls with WebLogic JDBC Spy, describes how to configure the WebLogic JDBC Spy, which logs JDBC usage.

 

---

Related Documentation

This document contains JDBC-specific driver information.

For comprehensive guidelines for developing, deploying, and monitoring WebLogic Server applications, see the following documents:

• Programming WebLogic JDBC is a guide to designing and using JDBC connections in your applications.

• Configure WebLogic JDBC is a guide to JDBC configuration and management for WebLogic Server.

• Developing Applications with WebLogic Server is a guide to developing WebLogic Server applications.

• Deploying Applications to WebLogic Server is the primary source of information about deploying WebLogic Server applications.

• WebLogic Server Performance and Tuning contains information on monitoring and improving the performance of WebLogic Server applications.

 

---

JDBC Samples and Tutorials

In addition to this document, Oracle 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.

 

Avitek Medical Records Application (MedRec) and Tutorials

MedRec is an end-to-end sample Java EE 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 Java EE features, and highlights Oracle-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 Server.

 

JDBC Examples in the WebLogic Server Distribution

WebLogic Server 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 Start menu.

 

---

New and Changed JDBC Features in This Release

For a comprehensive listing of the new WebLogic Server features introduced in this release, see “What's New in WebLogic Server” in Release Notes.