Integrating NonStop JDBC Type 4 Driver With IBM WebSphere Applications

Table 4. Choosing custom properties for the data source.

Name Value Type

URL

Location where the MXCS’s Association Server is running, in the form:

‘jdbc:t4sqlmx://<nsk host dns or IP address>:<MXCS server port>/:’

java.lang.String

User

Valid username on the NonStop system that has sufficient privileges to

access the Duke’s Bank sample database

java.lang.String

Password Password for the user java.lang.String

Catalog DUKECAT java.lang.String

Schema DUKESCHEMA java.lang.String

Saving the configuration changes

Now that all the necessary changes have been made, you will need to persist your changes by saving

the configuration. Click on Save on the top menu, as shown in figure 1.

Figure 1

In the screen that follows, press the Save button to finalize the changes to the Master configuration.

Testing the DukesDatabase data source

To test the newly created data source, click on the Resources Æ JDBC Providers link on the left panel.

Then on the right panel, click on the SQLMX Type 4 JDBC Provider. Scroll down to the bottom and

click on the Data Sources link.

Select the checkbox next to the DukesDatabase and click the Test Connection button. If the

configuration values were correctly provided, you will see a message similar to that shown in figure