The JDBC Advanced Samples demonstrate the usage 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  

JDBC RowSet DML Sample [12-Mar-2004]
This sample  application, demonstrates the usage of the JDBC RowSets in the DML operations. The data manipulation language (DML) operations include SELECT, INSERT, UPDATE, DELETE on a database table. RowSet is a JDBC 2.0 feature and is available only in JDK 1.2 or later.
In this sample application, the usage of JDBC RowSet in a Java application for simple DML operations is shown. The RowSet is used to connect  to an Oracle Database and to read/manipulate the data in the tables.
Download Now (JAR, 110KB)
Readme

BFILE Datatype [19-Feb-2003]
An external file, or BFILE, is used to store a locator to a file outside the database, stored somewhere on the filesystem of the data server. The locator points to the actual location of the file. This sample application demonstrates how to manipulate the BFile column type of a database table.
Download Now (JAR, 28KB)
Readme
Source

Column Type Performance Extension [19-Feb-2003]
Oracle JDBC drivers enable you to inform the driver of the types of the columns in an upcoming query, saving a round trip to the database that would otherwise be necessary to describe the table.This application illustrates the Column-Type Specification performance extension of Oracle JDBC drivers. 
Download Now (JAR, 17KB)
Readme
Source

Dynamic SQL [19-Feb-2003]
This application shows how to create and execute dynamic sql queries using JDBC. The user selects a table from his schema, then the columns and provides the where clause. The dynamic SQL query is then formed based on the user input and executed.
Download Now (JAR, 22KB)
Readme
Source

LOB Datatype [19-Feb-2003]
The term large object (LOB) refers to a data item that is too large to be stored directly in a database table. This sample application demonstrates how to read and write LOB datatype.The Oracle JDBC drivers provide support for two types of LOBs: BLOBs (unstructured binary data) and CLOBs (character data). BLOB and CLOB data is accessed and referenced using a locator stored in the database table.
Download Now (ZIP, 76KB)
Readme
Source

Java Object [19-Feb-2003]
Objects can be accessed either using oracle.sql.STRUCT or by defining custom Java Classes to represent the Oracle Object Type. This sample illustrates access of an Object Type using a java class generated by JPublisher, while retrieval using weakly typed objects (oracle.sql.STRUCT) is illustrated in Object Oracle Sample.
Download Now (JAR, 28KB)
Readme
Source

Oracle Object[19-Feb-2003]
This sample illustrates retrieval and manipulation of Objects from an Oracle9i database using JDBC. Objects can be accessed either using oracle.sql.STRUCT or by defining custom Java Classes to represent the Oracle Object Type. This sample illustrates access using the weakly typed objects (oracle.sql.STRUCT), while retrieval using strongly typed objects is illustrated in Object Java Sample.
Download Now (JAR, 25KB)
Readme
Source

Oracle Mapping [19-Feb-2003]
This sample illustrates oracle.sql mapping to retrieve data from the Oracle database. This sample actually converts the data types of oracle database into oracle.sql data types.
Download Now (JAR, 21KB)
Readme
Source

Row Prefetch Performance Extension [19-Feb-2003]
The row-prefetching feature associates an integer row-prefetch setting with a given statement object. JDBC fetches that number of rows at a time from the database during the query to get better performance. This sample illustrates how to set the row prefetch size value using JDBC APIs.
Download Now (JAR, 20KB)
Readme
Source

Stream Datatypes [19-Feb-2003]
This sample illustrates how data can be accessed as streams in JDBC. Using JDBC stream data can be read in various formats like Unicode, Binary and Ascii.
Download Now (JAR, 17KB)
Readme
Source