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






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