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.

Contents

  1. Web Rowsets

  2. Connection Cache

  3. Named Parameters

  4. IEEE datatypes - BINARY_DOUBLE and BINARY_FLOAT

  5. PL/SQL Index-by Tables


E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy