The Oracle9i JDBC 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  

Thin Driver Samples

Connection Cache Sample
Connection caching, generally implemented in a middle tier, is a means of keeping and using caches of physical database connections. This helps in improving the performance of the applications in the middle tier. This Sample Application illustrates how to use a Connection Cache in a typical middle tier application. Runs with Oracle9i v9.0.1 JDBC Driver and OC4J 1.0.2.2 and above.
Download Now (JAR, 25KB)
Readme
Source

Connection Wrapper Sample
This sample illustrates the usage of OracleConnectionWrapper (oracle.jdbc.OracleConnectionWrapper). Use of OracleConnectionWrapper prevents the developer from accessing the underlying OracleConnection and always accessing the wrapper instead. By wrapping oracle.jdbc.OracleConnection, there is central point of control while performing any JDBC call. Since all the JDBC calls have to be made through the Wrapper, the business logic can be implemented at one point thus implementing a single point of control and reducing code duplication.
Download Now (JAR, 20KB)
Readme
Source

Multiple Collection Support Sample
Multi-level collection types are collection types whose elements are themselves directly or indirectly another collection type. For ex : Nested Table of Nested Table type or Nested Table of VARRAY type etc. This Sample Application illustrates how to access Multiple Collections in your Java Code using Oracle9i JDBC Driver.
Download Now (JAR, 45KB)
Readme
Source

NCHAR Support for Unicode Data Sample
Unicode is a universal encoded character set that allows you to store information from any language using a single character set. Unicode provides a unique code value for every character, regardless of the platform, program, or language. Oracle9i JDBC drivers supports SQL NCHAR (NCHAR, NVARCHAR2 and NCLOB) datatypes which were created for Globalization Support (formerly NLS).This sample application illustrates the access and manipulation of Unicode data using a Product-Catalog application.
Download Now (JAR, 24KB)
Readme
Source

New LOB APIs and DateTime Support Sample
With the help of a simple Advertisement Management application, this sample application illustrates new LOB APIs to support temporary LOBs, trim(), open()/close() APIs and Datetime support in Oracle9i JDBC Driver. This Sample also illustrates accessing and manipulation of LOBs. Runs with Oracle9i v9.0.1 JDBC Drivers.
Download Now (JAR, 34KB)
Readme
Source

Object Type Inheritance Support Sample
Object-type inheritance feature allows a new object type to be created by extending another object type. The subtype automatically inherits all the attributes and methods defined in the supertype. This Sample Application illustrates Object type Inheritance features.
Download Now (JAR, 51KB)
Readme
Source

SQLJ Object Type Support
A SQLJ object type is a database object type designed for Java. A SQLJ object type maps to a Java class. Once the mapping is registered through the extended SQL CREATE TYPE command (a DDL statement), the Java application can insert or select the Java objects directly into or from the database through Oracle9i JDBC drivers. With the help of a simple HR scenario, this application shows how to access SQLJ Object Types in Java using Oracle9i JDBC Drivers.
Download Now (JAR, 29KB)
Readme
Source