Explanation of different DB2® JDBC providers in V5.0
 Technote (troubleshooting)
 
Problem(Abstract)
When creating a DB2® JDBC provider in WebSphere® Application Server 5.0.1 and higher, there are several choices of templates to use. This technote provides clarification on which template to use, depending on the DB2 database to which you are connecting.
 
Cause
Beginning in V5.0.1, it is important to select the correct DB2 JDBC Provider template based on the version of DB2 being connecting to and the platform the upon which the database is hosted.
 
Resolving the problem
When connecting to a DB2 V7.2 database, you can use these JDBC providers:
  • DB2 legacy CLI-based type 2 JDBC driver
  • DB2 legacy CLI-based type 2 JDBC driver (XA)

These templates are functionally equivalent to the DB2 JDBC provider and DB2 JDBC provider (XA) templates that were available in WebSphere Application Server V5.0.0. Although the DB2 JDBC provider templates can still be used in V5.0.1 or higher, they are deprecated and it is recommended that the DB2 legacy CLI-based type 2 JDBC driver templates be used instead.

When connecting to a DB2 8.1 database, you can use these JDBC Providers:
  • DB2 legacy CLI-based type 2 JDBC driver
  • DB2 legacy CLI-based type 2 JDBC driver (XA)
  • DB2 Universal JDBC Driver Provider
  • DB2 Universal JDBC Driver Provider (XA)

Use the DB2 legacy CLI-based type 2 JDBC driver templates to connect to DB2 with the type-2 JDBC app driver. This is the same driver that is used to connect to DB2 7.2 databases. In addition, you can use the DB2 Universal JDBC Driver Provider templates to use the new DB2 Universal JDBC Driver to connect to DB2 8.1 databases. Data sources using these JDBC provider templates have a custom property called driverType that must be set to 2 or 4 for type-2 Universal Driver or type-4 Universal Driver respectively. The type-2 Universal Driver supports XA; the type-4 Universal Driver does not support XA unless DB2 8.1 Fix Pack 7 (or higher) or DB2 8.2 is installed.

When connecting to a DB2/390 database, you can use these JDBC Providers:
  • DB2/390 JDBC Provider
  • DB2/390 JDBC Provider (XA)

Use these templates to connect to DB2 6.1 or 7.1 databases on OS/390 (zSeries). This configures WebSphere to use the type-2 JDBC app driver to connect to DB2/390.

When connecting to a DB2 database on iSeries, you can use these JDBC Providers:
  • DB2 UDB for iSeries (Native - V5R2 and later)
  • DB2 UDB for iSeries (Native XA - V5R2 and later)
  • DB2 UDB for iSeries (Native - V5R1 and earlier)
  • DB2 UDB for iSeries (Native XA - V5R1 and earlier)
  • DB2 UDB for iSeries (Toolbox)
  • DB2 UDB for iSeries (Toolbox XA)

These templates can be used as expected. The DB2 UDB for iSeries (Toolbox) templates can be used to connect to any release of DB2 on iSeries; the appropriate template must be selected for the release of DB2 on iSeries in use if one of the native templates is selected. Note that he Toolbox JDBC Driver is a type-4 driver, while the Native JDBC Driver is a type-2 driver.
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Data & Information Management DB2 Universal Database
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.0
Software edition:
Reference #: 1154345
IBM Group: Software Group
Modified date: Feb 11, 2005