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:
- Log in to the Integrated Solutions Console:
- 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.
- Enter an administrator user ID and password. (Omit the password if security is
not enabled.)
- Click Log in.
- In the navigation pane, click .
- Click the name of the JDBC provider for
the component you are installing.
- Under Additional Properties, click Data
sources.
- Select the associated check box for
the data source to test the connection.
- 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