Verifying a connection
Many connection problems can be fixed by verifying some configuration parameters. There are some steps that complete to enable a successful connection.
If the connection is still not successful after completing these steps and reviewing the applicable information, check the SystemOut.log for warning or exception messages. Then use the technical support search function to find known problems. See the IBM Suggests section of this article for a link to the IBM support and downloads page, which contains the search function.
- Create the authentication data alias. See the topic, Managing Java2 Connector Architecture authentication data entries.
- Create the JDBC provider. See the topic, Configuring JDBC providers using the admin console.
- Create a data source. See the topic, Set a data source using the admin console
- Save the data source.
- If we created a new authentication alias, restart the server for which we need to verify connectivity.
- Test the connection.
We can test the connection from the data source collection view or the data source details view. Access either view in the admin console, and then select a connection from the list. Click the Test Connection button on the connection.
See the topic, Test the connection service.
Test connection service
JDBC providers
Data sources
The benefits of using resource references
Data source lookups for enterprise beans and Web modules
Related tasks
Set a JDBC provider
Set a data source
Set a JDBC provider for a clustered environment
Create and configuring a JDBC provider and data source using the Java Management Extensions API
Manage Java 2 Connector Architecture authentication data entries
Related
Data source collection
Data source (WAS V4) collection
JDBC provider collection
Related information
Support and downloads: Technical support search function