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.
com.ibm.db2.jdbc.app.UDBConnectionPoolDataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.
com.ibm.db2.jdbc.app.UDBXADataSource
Requires JDBC driver files: db2_classes.jar
com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
Does not require an authentication alias.