The Oracle10g JDBC Samples demonstrate the use of various new features introduced in JDBC specification defined by Sun Microsystems.
All the samples have also been certified on Red Hat Linux Advanced Server 2.1  

Connection Cache Attributes Sample Application [26-Aug-2004]
This sample application demonstrates how to set attributes in a connection residing within a implicit connection cache. It also demonstrates various possibilities for searching the connection based on its attributes.
Download Now (JAR, 12KB)
Readme

Connection Cache Callback Sample [16-Jul-2004]
This sample application demonstrates how to implement the connection cache callback feature in an application. The implicit connection cache provides a mechanism for users to define cache behavior when a connection is returned to the cache. The callback mechanism is useful to override the default behavior of the cache while handling abandoned connections or when the cache is empty.
Download Now (JAR, 18KB)
Readme

CachedRowSet Sample [05-Mar-2004]
This sample application illustrates the usage of CachedRowSet. CachedRowSet is a rowset implementation where the rows are cached and the rowset does not have a live connection to the database (disconnected). OracleCachedRowSet is the implementation of CachedRowSet by Oracle and is used in this sample application. This sample can be run using a web browser or a mobile device.
Download Now (JAR, 1.6MB)
Readme

Connection Cache Sample [04-Feb-2004]
This sample illustrates the usage of connection caching features in Oracle Database 10g JDBC drivers. Connection caching, generally implemented in a middle tier, is a means of keeping and using caches of physical database connections. Oracle's implementation of Connection Caching uses the Connection Pooling Framework in much of its operations. With the addition of OracleConnectionCacheManager to Oracle Database 10g JDBC library, applications can use its rich set of administrative APIs to manage the connection cache. This class replaces the deprecated OracleConnectionCacheImpl. Applications can manage their cache either through the single OracleConnectionCacheManager instance or through the OracleDataSource associated with the cache.
Download Now (JAR, 37KB)
Readme
Source

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

PL/SQL Index by Tables Sample [04-Feb-2004]
This sample illustrates the use of PL/SQL Index-by Tables support for Scalar Types . Index-By Tables are one of the collections provided by PL/SQL to store arrays, lists, trees. They also help to move columns of data into and out of database tables or between client-side applications and stored subprograms. The use of Index-By Tables as IN and OUT parameters of a function is also illustrated here.
Download Now (JAR, 32KB)
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