Tutorial : Understanding the New Features of JDBC 3.0
Tutorial Series: Understanding
the New Features of Oracle 10g JDBC
JDBC is a key enterprise API that provides Java
applications with mid-level access to most database systems, via the
Structured Query Language (SQL). JDBC 3.0 brings with it a major change
with the inclusion of the package javax.sql (the JDBC Optional
Package) as well as the package java.sql.
Outside of various minor enhancements to the rest of the API, JDBC 3.0
also adds increased support for SQL99 features, extremely capable
transaction support, full read/write handling of BLOB and CLOB fields,
and URL datatypes.
This tutorial series is aimed at helping you understand the new
features of JDBC 3.0 in relation to the new enhancements that they
bring to the Oracle 10g
database. Specifically, we will be looking at the following features -
Web Rowsets, Connection Cache, and Named Parameters, IEEE datatypes -
BINARY_DOUBLE and BINARY_FLOAT, and PL/SQL Index-by Tables. Each of
these new features will be dealt in relation to the sample applications
that OTN developers have built around these new features. In addition
to these features, you will also benefit from reading the tutorial
series on RowSet Implementations.