JDBC 2.0 Samples
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
|