JDBC driver architecture known as the 

IBM DB2 JDBC Universal Driver

. 

The Universal Driver is architected as an abstract JDBC processor that is 

independent of driver type connectivity or target platform. Examples of JDBC 

calls can be found in 

sqllib/samplesjava/jdbc. 

For detailed information on the 

Java support provided by DB2 Version 8, we strongly recommend the 

whitepaper 

Developing Enterprise Java Applications Using DB2 Version 8

:

http://www.ibm.com/developerworks/db2/library/techarticle/0209hutchison/020

9hutchison.html

Embedded SQL for Java (SQLj)

DB2 Java embedded SQL (SQLj) support is provided by the DB2 AD Client. With 

DB2 SQLj support, in addition to DB2 JDBC support, SQLj applets, applications 

and stored procedures can be built to contain static SQL and use embedded 

SQL statements that are bound to a DB2 database.

SQLj applications use JDBC as a foundation for tasks such as connecting to 

databases and handling SQL errors, but also contain embedded static SQL 

statements in separate SQLj source files. Unlike the other languages that can 

contain embedded SQL (COBOL, C, C++) the Java code is not precompiled, 

instead the SQLj translator converts SQLj clauses into JDBC statements. As 

SQLj shares its underlying connection with that of JDBC, applications, it can 

connect to DB2 using either type 2, type 3, or type 4 drivers.

Examples of SQLj calls can be found in sqllib/samplesjava/sqlj.

More detailed 

information can also be found in article  Developing Enterprise Java Applications 

Using DB2 Version at: 

http://www 106.ibm.com/developerworks/db2/library/techarticle/0209hutch

ison/0209hutchison.html 

ActiveX Data Objects and Remote Data Objects (Windows only)

DB2 supports ActiveX Data Object (ADO) applications that use the Microsoft 

OLE DB to ODBC bridge. ActiveX Data Objects (ADO) allows you to write 

applications to access and manipulate data in a database server through an 

OLEDB provider.

When installing the client version of DB2 Version 8.1 for Windows, optionally 

IBMDADB2, the IBM OLE DB 2.0 compliant provider for DB2 can also be 

installed. With this driver the DB2 database does not have to be cataloged as an 

ODBC data source. 

Remote Data Objects (RDO) provide an information model for accessing remote 

data sources through ODBC. RDO offers a set of objects that make it easy to 

connect to a database, execute queries and stored procedures, manipulate 

results, and commit changes to the server. As RDO implements a thin code layer 

 Chapter 1. Introduction 

27