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.
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.