1. IBM WebSphere Portal for Microsoft Windows Guide
  2. Verifying Database Connections

Verifying Database Connections

After you configure IBM® WebSphere® Portal to work with your database, test the database connection to ensure that it operates correctly. Then verify that all database transactions work properly within the WebSphere Portal environment. For example, all portal pages should display without HTTP 404 errors, and there should be no database layer-related exceptions in the SystemOut.log and SystemErr.log files.

You can verify the database connection using IBM WebSphere Application Server or by opening WebSphere Portal in a browser.

To verify that the WebSphere Portal application server is running by using WebSphere Application Server, complete these steps:

  1. Open the WebSphere Application Server administrative console by entering the following address in a browser:

    http://hostname.example.com:10001/ibm/console

    where hostname.example.com is the fully qualified host name of the machine where WebSphere Portal is running and 10042 is the default transport port that is created by WebSphere Application Server.

  2. Log into the administrative console.

  3. Click Resources, JDBC, JDBC Providers.

  4. Select all scopes (the default setting) or select a specific cell, node, or node/server.

    Select the scope that corresponds to your instance of WebSphere Portal.

    The view refreshes.

  5. Select the name of the data source that is defined in wkplc_dbdomain.properties.

    The default data source is wpdbDS.

  6. Select the name of the JDBC provider that is specified in wkplc_dbtype.properties.

    The default JDBC provider is wpdbJDBC_dbtype, where dbtype is replaced by the value that matches your environment.

  7. Click Test Connection to verify the database connection.

    If configuration parameters have been changed, you might need to restart WebSphere Application Server for the test to complete.

To verify that the WebSphere Portal application server is running by opening WebSphere Portal in a browser, enter the following URL in a supported browser:

http://hostname.example.com:10039/wps/portal

where hostname.example.com is the fully qualified host name of the machine, where WebSphere Portal is running and 10039 is the default transport port that is created by WebSphere Application Server.