The JDBC 3.0 Samples show how to use the new features defined by the JDBC 3.0 standard. All the samples have also been certified on Red Hat Linux Advanced Server 2.1  

IEEE Datatypes Sample [04-Feb-2004]
This sample application illustrates the new JDBC 3.0 feature: Support for IEEE datatypes BINARY_DOUBLE and BINARY_FLOAT within the Oracle Database 10g as well as from the Oracle JDBC 10g.
Download Now (JAR, 100KB)
Readme
Source

Named Parameters Sample [04-Feb-2004]
From JDBC 3.0 onwards, it is possible to use named binding to the parameters in the CallableStatement object. Like the Oracle PL/SQL, the JDBC applications can now use both named and ordinal binding.
Download Now (JAR, 68KB)
Readme
Source

Web RowSet Sample [04-Feb-2004]
Web RowSet, a new feature in Oracle Database 10g JDBC driver. Web RowSet represents a set of fetched rows that can be passed between tiers and components. The data can be obtained in the XML format that can be managed either by storing it in a String or writing it to a file in the local file system. This sample demonstrates the usage of webrowsets in a web application.
Download Now (JAR, 238KB)
Readme
Source

Save Point Sample [03-Mar-2003]
This sample illustrates usage of a new JDBC 3.0 feature namely Save Point. Save Points provide fine-grained control of transactions by marking intermediate points within a transaction. Once a save point has been set, the transaction can be rolled back to that save point without affecting preceding work. Thus Save Point interface allows you to partition a transaction into logical breakpoints, providing control over how much of the transaction gets rolled back. With the help of a simple Banking Scenario, this sample illustrates essential features of Save Point Support in Oracle9i JDBC Drivers.
Download Now (JAR, 34KB)
Readme
Source

Statement Caching Sample[03-Mar-2003]
Statement Caching prevents the overhead of repeated statement parsing and cursor creation by caching the statement state and meta data. There are two schemes available for statement caching a) Implicit Statement Caching b) Explicit Statement Caching. With the help of a Simple 'Employee Search Application' Scenario, this sample illustrates benefits and usage of Statement Caching.
Download Now (JAR, 27KB)
Readme
Source

Transaction Toggling Sample [03-Mar-2003]
This sample illustrates the usage of the JDBC 3.0 feature, sharing connection between local and global transactions (transaction toggling) in Oracle JDBC. The JDBC 3.0 specification defines that a Connection object may operate in either local or global mode, and allows it to switch between these two modes. At any point a connection can be in one of three valid modes : NO_TXN, LOCAL_TXN, or GLOBAL_TXN. NO_TXN indicates that no transaction is actively using this Connection; LOCAL_TXN indicates that a local transaction that requires explicit commit (i.e., with auto-commit off/disabled) is actively using this Connection; and GLOBAL_TXN indicates that a global transaction is actively using this Connection. With the help of a simple Shopping Cart application this sample illustrates how to toggle between local and global transactions.
Download Now (JAR, 82KB)
Readme
Source