Client tier

Server tier 

Middle tier

Java Application

DB2 JDBC applet 

server

DB2     

DB2 JDBC Type 3 

Database

Driver

Figure 7 2   DB2 JDBC type 3 driver

DB2 Universal JDBC driver

The DB2 JDBC Universal Driver is a single driver that include both type 2 and 

type 4 behavior. This type 4/ Native protocol all Java driver is implemented in 

Java and it uses the Distributed Relational Database Architecture  (DRDA ) 

protocol for client/server communications. Figure 7 3 shows the JDBC 

Universal Driver usage in the Java application. DB2 Universal JDBC Driver 

does not need any service on client side, this driver is available in the 

db2jcc.jar.

For using the DB2 Universal JDBC driver, you need the following properties:

drivername= com.ibm.db2.jcc.DB2Driver 

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

Note: Servername and serverport refer to the database server.

Client tier

Server tier 

Java Application

DRDA Protocol

DB2 Universal 

DB2     

Driver

Database

Figure 7 3   JDBC Universal Driver

 Chapter 7. Application porting 

191