These properties vary according to the database vendor requirements for JDBC driver implementations. You must set the appropriate properties on every data source that you configure. These settings are for a DB2 UDB data source.
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 V5R2, or later releases.
com.ibm.db2.jdbc.app.UDBConnectionPoolDataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
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.
com.ibm.db2.jdbc.app.UDBXADataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
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 systems.
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource
Requires JDBC driver files: jt400.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias if WebSphere Application Server and DB2 UDB for iSeries are installed in the same server. If they are installed in different servers, the user ID and password are required.
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.
com.ibm.as400.access.AS400JDBCXADataSource
Requires JDBC driver files: jt400.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias if WebSphere Application Server and DB2 UDB for iSeries are installed in the same server. If they are installed in different servers, the user ID and password are required.
This JDBC provider is deprecated because it corresponds to a version of the iSeries operating system that WebSphere Application Server Version 6.x does not support. You must now use iSeries V5R2 or a later release of the iSeries operating system, for which the WebSphere Application Server administrative console lists one native iSeries DB2 non-XA provider: DB2 UDB for iSeries (Native).
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.
com.ibm.db2.jdbc.app.DB2StdConnectionPoolDataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
This JDBC provider is deprecated because it corresponds to a version of the iSeries operating system that WebSphere Application Server Version 6.x does not support. You must now use iSeries V5R2 or a later release of the iSeries operating system, for which the administrative console lists one native iSeries DB2 XA provider: DB2 UDB for iSeries (Native).
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.
com.ibm.db2.jdbc.app.DB2StdXADataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
The DB2 legacy CLI-based Type 2 JDBC Driver Provider is built on top of DB2 CLI (Call Level Interface). It uses the DB2 CLI interface to communicate with DB2 UDB servers. This provider is intended for remote connections to DB2 running on iSeries. For use with Application Server on Windows, supported UNIX systems, or workstation-based Linux systems, it therefore requires the DB2 Connect Driver (which is available from DB2).
COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
Requires JDBC driver files: db2java.zip (Note: If you run SQLJ in DB2 Version 8, db2jcc.jar is also required.)
com.ibm.websphere.rsadapter.DB2DataStoreHelper
Does not require a valid authentication alias.
The DB2 legacy CLI-based Type 2 JDBC Driver (XA) is built on top of DB2 CLI (Call Level Interface). It uses the DB2 CLI interface to communicate with DB2 UDB servers. This provider is intended for remote connections to DB2 running on iSeries; for use with Application Server on Windows, supported UNIX systems, or workstation-based Linux systems, it therefore requires the DB2 Connect Driver (which is available from DB2).
COM.ibm.db2.jdbc.DB2XADataSource
Requires JDBC driver files: db2java.zip
com.ibm.websphere.rsadapter.DB2DataStoreHelper
Does not require a valid authentication alias.
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 V5R2 or later releases, only if you cannot use the DB2 UDB for iSeries (Native) provider.
com.ibm.db2.jdbc.app.UDBConnectionPoolDataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
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 only if you cannot use the DB2 UDB for iSeries (Native XA) provider.
com.ibm.db2.jdbc.app.UDBXADataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
If you need to connect to DB2 UDB on iSeries to provide JDBC connectivity for an application run on WebSphere Application Server for z/OS, you can use the iSeries Toolbox driver for Java, the iSeries Toolbox XA-compliant driver for Java, or the DB2 JDBC Universal Driver XA.
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 systems.
com.ibm.as400.access.AS400JDBCConnectionPoolDataSource
Requires JDBC driver files: jt400.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Requires an authentication alias.
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.
com.ibm.as400.access.AS400JDBCXADataSource
Requires JDBC driver files: jt400.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Requires an authentication alias.
The DB2 Universal JDBC Driver provider (XA) allows applications to use both JDBC and Structured Query Language in Java (SQLJ) access to DB2 databases. SQLJ use with CMP is also supported.
This provider does not support the creation of Version 4.0 data sources.
com.ibm.db2.jcc.DB2XADataSourceNote that when you configure the data source, you must specify a name for the data source definition.
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar
${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar
${DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH}(In cases that do not require native files, set the DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH to null.)
com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
It also requires a valid authentication alias.