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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved