The JDBC 2.0 Samples show how to use the new features defined by the JDBC 2.0 standard. These new features are available in the Oracle8i Release 2 (version 8.1.6) JDBC drivers. All the samples have also been certified on Red Hat Linux Advanced Server 2.1  

Batch Update [20-Feb-2003]
This sample shows how to perform batch updates, in other words, send multiple updates to the database to be executed as a batch rather than sending each update separately. Runs with Oracle8i Release 2 (version 8.1.6) JDBC drivers.
Download Now (JAR, 29KB)
Readme
Source

Connection Pooling [20-Feb-2003]
Connection pooling is a mechanism by which an application can recycle a connection that is closed. This is achieved by returning the connection to a connection pool. As establishing a connection is an expensive operation, reusing connections can improve performance dramatically. This sample shows how connection pooling mechanism can be used in a middle tier. Runs with Oracle8i Release 2 (version 8.1.6) JDBC drivers.
Download Now (JAR, 61KB)
Readme
Source

Distributed Transactions [20-Feb-2003]
This sample shows how to implement a distributed transaction, sometimes referred to as a global transaction, which is a set of two or more related transactions that must be managed in a coordinated way. The transactions that constitute a distributed transaction might be in the same database, but more typically are in different databases and often in different locations. Runs with Oracle8i Release 2 (version 8.1.6) JDBC drivers.
Download Now (JAR, 27KB)
Readme
Source

Programmatic Updates [20-Feb-2003]
Programmatic updates provide the ability to make updates using the JDBC 2.0 API rather than sending SQL statements. This application illustrates how to insert, update and delete records programatically using the JDBC 2.0 API. Runs with Oracle8i Release 2 (version 8.1.6) JDBC drivers.
Download Now (JAR, 26KB)
Readme
Source

Scrollable Result Set [20-Feb-2003]
Scrollable result sets provide the ability to move the cursor forward and backward to a specified position or to a position relative to the current one. This sample shows how JDBC 2.0 API can be used to browse the Result Sets. Runs with Oracle8i Release 2 (version 8.1.6) JDBC drivers.
Download Now (JAR, 24KB)
Readme
Source

Collections (Strongly Typed) [20-Feb-2003]
This Sample illustrates accessing of Collections (i.e Nested Tables and Varrays) from the Database Columns using JDBC. The Sample also demonstrates accessing of Object References. Object References along with the collections allows us to easily model Master-Detail Relationship in Object-Oriented Databases.
Download Now (JAR, 28KB)
Readme
Source

Collections (Weakly Typed) [20-Feb-2003]
This sample shows how to access Collections (i.e. Nested Tables and Varrays) and Object References using the JDBC 2.0 API. Object References and collections allow easy modelling of Master-Detail Relationship in Object-Oriented Databases. Runs with Oracle8i Release 2 (version 8.1.6) JDBC drivers.
Download Now (JAR, 26KB)
Readme
Source