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 Cloudscape data sources.
(For WebSphere Application Server v6.02, only Cloudscape v10.0 applies)
The Derby JDBC driver provides JDBC access to the Cloudscape v10.x database by using the framework that is already embedded in WebSphere Application Server for Cloudscape. However, you cannot use any Version 4.0 data sources with Cloudscape v10.x.
org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource
Requires JDBC driver files: derby.jar; full path name: ${WAS_APP_SERVER_ROOT}/derby/lib/derby.jar
com.ibm.websphere.rsadapter.DerbyDataStoreHelper
Does not require a valid authentication alias.
The Derby JDBC driver (XA) provides JDBC access to the Cloudscape v10.x database by using the framework that is already embedded in WebSphere Application Server for Cloudscape. However, you cannot use any Version 4.0 data sources with Cloudscape v10.x.
org.apache.derby.jdbc.EmbeddedXADataSource
Requires JDBC driver files: derby.jar; full path name: ${WAS_APP_SERVER_ROOT}/derby/lib/derby.jar
com.ibm.websphere.rsadapter.DerbyDataStoreHelper
Does not require a valid authentication alias.
The Derby Network Server using the Universal JDBC Driver takes advantage of the Network Server support that the DB2 Universal JDBC Driver type 4 provides. You cannot use any Version 4.0 data sources with Cloudscape v10.x.
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
Requires JDBC driver files:
<classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar</classpath> <classpath>${CLOUDSCAPE_JDBC_DRIVER_PATH}/otherJars/db2jcc.jar</classpath> <classpath>${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar</classpath>which means that the db2jcc.jar from DB2 always takes precedence. Note that this also means that you must set the DB2 environment variable DB2UNIVERSAL_JDBC_DRIVER_PATH in WebSphere Application Server when you set up your DB2 data source. This is instead of hard coding the path of the db2jcc.jar for DB2 data sources.
com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
Requires a valid authentication alias.
See the Configuring Derby Version 10 topic for more information on configuring the Derby Network Server.
To learn more about the new Cloudscape code base, visit the Open Source Apache Derby Project Web site or the IBM Cloudscape version 10.0 information center.
The Cloudscape JDBC Provider provides the JDBC access to the Cloudscape database. This Cloudscape JDBC driver uses the embedded framework. You cannot use any Version 4.0 data sources with Cloudscape.
com.ibm.db2j.jdbc.DB2jConnectionPoolDataSource
Requires the JDBC driver files in db2jcc.jar
com.ibm.websphere.rsadapter.CloudscapeDataStoreHelper
Does not require a valid authentication alias.
The Cloudscape JDBC Provider (XA) provides the XA-compliant JDBC access to the Cloudscape database. This Cloudscape JDBC driver uses the embedded framework. You cannot use any Version 4.0 data sources with Cloudscape.
com.ibm.db2j.jdbc.DB2jXADataSource
Requires the JDBC driver files in db2jcc.jar
com.ibm.websphere.rsadapter.CloudscapeDataStoreHelper
Does not require a valid authentication alias.
This Cloudscape driver takes advantage of the Network Server support that the DB2 Universal JDBC Driver type 4 provides. You cannot use any Version 4.0 data sources with Cloudscape.
com.ibm.db2.jcc.DB2ConnectionPoolDataSource
Requires JDBC driver files:
<classpath>${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar</classpath> <classpath>${CLOUDSCAPE_JDBC_DRIVER_PATH}/db2j.jar</classpath> <classpath>${CLOUDSCAPE51_JDBC_DRIVER_PATH}/db2j.jar</classpath> <classpath>${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar</classpath>which means that the db2jcc.jar from DB2 always takes precedence. Note that this also means that you must set the DB2 environment variable DB2UNIVERSAL_JDBC_DRIVER_PATH in WebSphere when you set up your DB2 data source. This is instead of hard coding the path of the db2jcc.jar for DB2 data sources.
com.ibm.websphere.rsadapter.CloudscapeNetworkServerDataStoreHelper
Note: The administrative console incorrectly lists the DB2UniversalDataStoreHelper as the default value for the DataStoreHelper class. You must change the default value to com.ibm.websphere.rsadapter.CloudscapeNetworkServerDataStoreHelper. Also change the custom properties, using the instructions in the customer property section.
Requires a valid authentication alias.
See the Cloudscape setup instructions for more information on configuring the Cloudscape Network Server.
For more information, visit the IBM Cloudscape version 5.1.x publications center.