Integrating JDBC Type 4 Driver 2.0 With IBM WebSphere Applications

Table 2. Details for configuring the NonStop JDBC Type 4 Driver.
Property Value
Name SQLMX Type 4 JDBC Provider
Description SQL/MX JDBC 3.0-compliant provider configuration
Classpath ${USER_INSTALL_ROOT}/nonstop/t4sqlmx.jar
Implementation classname com.tandem.t4jdbc.SQLMXConnectionPoolDataSource
To configure any datasource as XA datasource, include the following class in the Implementation
classname
com.tandem.t4jdbc.SQLMXXADataSource
Click the Apply button. The same screen will reappear.
Configuring a data source for the new JDBC provider
On the same screen, scroll to the bottom and click on Data Sources in the Additional Properties
section. This will bring you to the screen where you can provide the configuration details for the data
source you want to add. Enter the information shown in table 3.
Table 3. Details for configuring the data source.
Property Value
Name $ DukesDatabase
JNDI name jdbc/DukesDB
Container managed persistence Select the checkbox
Statement cache size 10
Datasource helper classname com.ibm.websphere.rsadapter.GenericDataStoreHelper
Component-managed authentication alias None
Container-managed authentication alias None
Mapping-configuration alias DefaultPrincipalMapping
Click the Apply button. The same screen will reappear.
Specifying custom properties for the data source
On the same screen, scroll to the bottom and click on Custom Properties in the Additional Properties
section. Clicking the New button will cause a configuration screen to appear. From here you can
enter a new name/value pair. Create the following name/value pairs by entering the information
shown in table 4 on the screen (one name/value pair at a time) and clicking OK.
Table 4. Choosing custom properties for the data source.
6