WebSphere brand IBM WebSphere IP Multimedia Subsystem Connector, Version 6.2

Testing the database connection

After creating the data source, use the Integrated Solutions Console to test the connection to the database.

Before you begin
Note: This procedure should only be used if the database client or JDBC JAR files are present, which may not be the case on the deployment manager.
Before you begin, the following software should be installed:
  • WebSphere® Application Server Network Deployment, version 7.0.0.7
  • One of the following supported databases:
    • IBM® DB2® Enterprise Server Edition, version 9.5.0.4 or 9.7.0.1
    • Oracle Database, version 11.1.0.7 or 11.2.0.1
  • JDBC JAR file or full database client for communicating with the database server
  • Diameter Enabler base
Before you begin, you should have already completed the following steps:
  • Started the application server
  • Created the database
  • Created WebSphere variables
  • Created an authentication alias for the database
  • Created the JDBC provider
  • Defined the data source
About this task

Complete the following steps to test the mapped database connection:

  1. Log in to the Integrated Solutions Console:
    1. Open a browser and navigate to the following URL: https://host_name:port/ibm/console.
      Where:
      • host_name is the fully qualified host name of the server where the application or the network deployment manager is deployed.
      • port is the secured port used to access the console. The default port is 9043.
      Note: The default unsecured port is 9060. If you use 9060, you must have "http" instead of "https" in the URL.
    2. Enter an administrator user ID and password. (Omit the password if security is not enabled.)
    3. Click Log in.
  2. In the navigation pane, click Resources > JDBC > JDBC Providers.
  3. Click the name of the JDBC provider for the component you are installing.
  4. Under Additional Properties, click Data sources.
  5. Select the associated check box for the data source to test the connection.
  6. Click Test connection. A message similar to the following indicates a successful connection:
    Test connection for data source datasource_name on server server_name
    at node node_name was successful.
    Where:
    • datasource_name represents the name of the data source you created
    • server_name represents the name of the server where you created the data source
    • node_name represents the node that contains server_name



Terms of use
(C) Copyright IBM Corporation 2009. All Rights Reserved.