Client tier

Java Application

Server tier 

DB2 JDBC Type2                    

Driver

DB2     

Database

DB2 CLI

DB2 

Client

Figure 7 1   DB2 type 2 JDBC Driver

Note:

 The DB2 JDBC type 2 driver is J2EE certified for use with IBM 

WebSphere Application Server, which means it conforms to J2EE 

specifications.

DB2 JDBC type 3 driver

The DB2 JDBC type 3 driver also called the 

applet or net protocol/all Java 

driver

 and follows a three tiered approach. In the DB2 JDBC type 3 driver, 

the Java standalone application or Java applet passes the JDBC database 

requests through the network to the middle tier server where the DB2 applet 

server is running. The DB2 applet server then translates the request (directly 

or indirectly) to the database specific native connectivity interface to pass the 

request to the database server. Figure 7 2 shows the various tiers involved in 

DB2 JDBC type 3 driver. The DB2 JDBC server process is 

db2jd

 and the 

driver is available in the 

db2java.zip

 in directory 

sqllib/java

.

For using DB2 JDBC type 3 driver you need following properties:

drivername= COM.ibm.db2.jdbc.net.DB2Driver 

URL= java:db2://servername:serverport/dbname 

Note:

 Here servername and serverport are the applet server port.

Note:

 The JDBC type 3 driver is deprecated for DB2 UDB Version 8.

190 

MySQL to DB2 UDB Conversion Guide