Oracle8i JDBC Developer's Guide and Reference Release 3 (8.1.7) Part Number A83724-01 |
Library | Service | Contents | Index

## 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.

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index