Use the Test button to test connectivity to a database endpoint. This feature is not only a test of network connectivity but also serves to verify whether you have provided the correct JDBC driver and that the endpoint database is running. It also verifies that you have the correct host name, port, user name, and password.
To test a new database connection endpoint:
Create a new database connection endpoint.
Test the connection one of the following ways:
When using the
New Endpoint Wizard to configure
a database endpoint connection, click the Test button.
If you click Test after you have made changes but have not clicked
Apply, you are testing the changes you have made since you last saved.
This allows you change values for a database connection and test the connection
before you apply the changes.
In the Endpoint Manager, right-click on an endpoint configuration and select Edit. The new dialog appears. Click the Test button.
In the Endpoint Manager, right-click on an endpoint configuration and select Test.
A message dialog notifies you of success or failure of the test.
Note: If a test of
a database endpoint fails, check the following:
- Verify that you have specified the correct JDBC driver files.
- Verify endpoint properties.
- Verify that the database service is actually running and accessible on
the network.
- Verify the driver is specified in the JDBC Driver Paths preferences.
See JDBC Driver Path Preferences.