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

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