Available JDBC providers

The following list contains descriptions for JDBC providers supported in WebSphere Application Server - Express. It also shows the supported data source classes and required properties.

Specific fields are designated for the user and password properties. Inclusion of a property in the list does not imply that you should add them it to the data source properties list. Rather, inclusion in the list means that a value is typically required for that field.

1. DB2 UDB for iSeries (Native - Version 5 Release 2 and later)
   The iSeries Developer Kit for Java contains this Type 2 JDBC driver that is built on top of the iSeries DB2 Call Level Interface (CLI) native libraries. Use this driver for local DB2 connections on the iSeries server. It is not recommended for remote access. Use this driver for OS/400 V5R2 or later releases.

   • DB2 UDB for iSeries (OS/400 V5R2 and later) supports one phase data source:
     

     com.ibm.db2.jdbc.app.UDBConnectionPoolDataSource

   • This driver requires the db2_classes.jar JDBC driver file.

   • This driver requires the following DataStoreHelper class:
     

     com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

   • This driver requires the following property:
     databaseName: The name of the relational database to which the data source connections are established. This name must appear in the iSeries Relational Database Directory. The default is *LOCAL.

2. DB2 UDB for iSeries (Native XA - Version 5 Release 2 and later)
   The iSeries Developer Kit for Java contains this XA-compliant Type 2 JDBC driver built on top of the iSeries DB2 Call Level Interface (CLI) native libraries. Only use this driver for local DB2 connections on iSeries. It is not recommended for remote access. Use this driver for iSeries V5R2 or later releases.

   • DB2 UDB for iSeries (Native XA - V5R2 and later) supports two phase data source:
     

     com.ibm.db2.jdbc.app.UDBXADataSource

   • This driver requires the db2_classes.jar * JDBC driver files.

   • This driver requires the following DataStoreHelper class:
     

     com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

   • This driver requires the following property:
     databaseName: The name of the relational database to which the data source connections are established. This name must appear in the iSeries Relational Database Directory. The default is *LOCAL.

3. DB2 UDB for iSeries (Native - Version 5 Release 1 and earlier)
   The iSeries Developer Kit for Java contains this Type 2 JDBC driver that is built on top of the iSeries DB2 Call Level Interface (CLI) native libraries. Only use this driver for local DB2 connections on iSeries. It is not recommended for remote access. Use this driver for iSeries V5R1, or earlier releases.

   • DB2 UDB for iSeries (Native V5R1 and earlier) supports one phase data source:
     

     com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource

   • This driver requires the db2_classes.jar * JDBC driver files.

   • This driver requires the following DataStoreHelper class:
     

     com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

   • This driver requires the following property:
     databaseName: The name of the relational database to which the data source connections are established. This name must appear in the iSeries Relational Database Directory. The default is *LOCAL.

   The V5R1 and earlier JDBC drivers are supported, but will not receive any future enhancements. It is recommended that you replace them with the V5R2 JDBC driver providers whenever possible.

4. DB2 UDB for iSeries (Native XA - Version 5 Release 1 and earlier)
   The iSeries Developer Kit for Java contains this XA-compliant Type 2 JDBC driver built on top of the iSeries DB2 Call Level Interface (CLI) native libraries. Only use this driver for local DB2 connections on iSeries. It is not recommended for remote access. Use this driver for iSeries V5R1, or earlier releases.

   • DB2 UDB for iSeries (Native XA - V5R1 and earlier) supports two phase data source:
     

     com.ibm.db2.jdbc.app.DB2StdXADataSource

   • This driver requires the db2_classes.jar JDBC driver files.

   • This driver requires the following DataStoreHelper class:
     

     com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

   • This driver requires the following properties:
     databaseName: The name of the relational database to which the data source connections are established. This name must appear in the iSeries Relational Database Directory. The default is *LOCAL.

   The V5R1 and earlier JDBC drivers are supported, but will not receive any future enhancements. It is recommended that you replace them with the V5R2 JDBC driver providers whenever possible.

5. DB2 UDB for iSeries (Toolbox)
   This JDBC driver, also known as iSeries Toolbox driver for Java, is provided in the DB2 for iSeries database server. Use this driver for remote DB2 connections on iSeries. We recommend you use this driver instead of the IBM Developer Kit for Java JDBC Driver to access remote DB2 UDB for iSeries servers.

   • DB2 UDB for iSeries (Toolbox) supports one phase data source:
     

     com.ibm.as400.access.AS400JDBCConnectionPoolDataSource

   • This driver requires the jt400.jar * JDBC driver files.

   • This driver requires the following DataStoreHelper class:
     

     com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

   • This driver requires the following property:
     serverName: The name of the server from which the data source obtains connections. Example: myserver.mydomain.com.

6. DB2 UDB for iSeries (Toolbox XA)
   This XA compliant JDBC driver, also known as iSeries Toolbox XA compliant driver for Java, is provided in the DB2 for iSeries database server. Use this driver for remote DB2 connections on iSeries. We recommend you use this driver instead of the IBM Developer Kit for Java JDBC Driver to access remote DB2 UDB for iSeries systems.

   • DB2 UDB for iSeries (Toolbox XA) supports two phase data source:
     

     com.ibm.as400.access.AS400JDBCXADataSource

   • This driver requires the jt400.jar JDBC driver files.

   • This driver requires the following DataStoreHelper class:
     

     com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper

   • This driver requires the following property:
     serverName: The name of the server from which the data source obtains connections. Example: myserver.mydomain.com.

For more information on DB2 UDB for iSeries, see the following Web site:

DB2 Universal Database for iSeries Web site
http://www.ibm.com/servers/eserver/iseries/db2/