Oracle8i JDBC Developer's Guide and Reference
Release 3 (8.1.7)

Part Number A83724-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Overview of JDBC 2.0 Features

Table 4-1 lists key areas of JDBC 2.0 functionality and points to where you can go in this manual for more information about Oracle support.

Table 4-1 Key Areas of JDBC 2.0 Functionality
Feature  Comments and References 

update batching  

Also available previously as an Oracle extension. With release 8.1.6 and higher, under either JDK 1.2.x or JDK 1.1.x you can use either the standard update batching model or the Oracle model.

See "Update Batching" for information.  

result set enhancements (scrollable and updatable result sets)  

With release 8.1.6 and higher, this is also available under JDK 1.1.x as an Oracle extension.

See Chapter 12, "Result Set Enhancements" for information.  

fetch size / row prefetching  

With release 8.1.6 and higher, the JDBC 2.0 fetch size feature is also available under JDK 1.1.x as an Oracle extension.

Under either JDK 1.2.x or JDK 1.1.x, you can also use Oracle row prefetching, which is largely equivalent to the JDBC 2.0 fetch size feature but predates JDBC 2.0.

See "Fetch Size" and "Oracle Row Prefetching" for information.  

use of JNDI (Java Naming and Directory Interface) to specify and obtain database connections  

This requires data sources, which are part of the JDBC 2.0 Optional Package (JDBC 2.0 Standard Extension API) in the javax.sql package. With release 8.1.6 and higher this is available under either JDK 1.2.x or JDK 1.1.x.

See "A Brief Overview of Oracle Data Source Support for JNDI" and "Creating a Data Source Instance, Registering with JNDI, and Connecting" for information.  

connection pooling (framework for connection caching)  

This requires the JDBC 2.0 Optional Package (JDBC 2.0 Standard Extension API) in the javax.sql package. With release 8.1.6 and higher this is available under either JDK 1.2.x or 1.1.x.

See "Connection Pooling" for information.  

connection caching (sample Oracle implementation)  

This requires the JDBC 2.0 Optional Package (JDBC 2.0 Standard Extension API) in the javax.sql package. With release 8.1.6 and higher, this is available under either JDK 1.2.x or 1.1.x.

See "Connection Caching" for information.  

distributed transactions / XA functionality  

This requires the JDBC 2.0 Optional Package (JDBC 2.0 Standard Extension API) in the javax.sql package. With release 8.1.6 and higher,, this is available under either JDK 1.2.x or 1.1.x.

See Chapter 16, "Distributed Transactions" for information.  

miscellaneous getXXX() methods  

See "Other getXXX() Methods" for information about which getXXX() methods are Oracle extensions under JDK 1.2.x and 1.1.x, and about any differences in functionality with JDBC 2.0.  

miscellaneous setXXX() methods  

See "Other setXXX() Methods" for information about which setXXX() methods are Oracle extensions under JDK 1.2.x and 1.1.x, and about any differences in functionality with JDBC 2.0.  


Note:

The 8.1.6 and higher Oracle JDBC drivers do not support the Calendar datatype because it is not yet feasible to support java.sql.Date timezone information. Calendar input to setXXX() or getXXX() method calls for Date, Time, and Timestamp is ignored. The Calendar type will be supported in a future Oracle release.  




Go to previous page
Go to beginning of chapter
Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index