WAS v8.5 > Administer applications and their environment > Welcome to administering Data access resources > Administer data access applications > Configure a JDBC provider and data source

Verifying a data source connection

Many connection problems can be easily fixed by verifying configuration parameters. There are steps that you must complete to enable a successful connection. If your 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.

  1. Create the authentication data alias. See the topic, Managing Java 2 Connector Architecture authentication data entries.

  2. Create the JDBC provider. See the topic, Configuring JDBC providers using the dmgr console.

  3. Create a data source. See the topic, Configuring a data source using the dmgr console

  4. Save the data source.
  5. Verify the connectivity if you created an authentication alias. To verify connectivity, restart the server for which verify connectivity.

    If we are using scripting or JMX to create the authentication alias, we can use the updateAuthDataCfg MBean. We can use this MBean method to refresh the authentication data in each server where it is needed. When creating a data source and the data source has not been used, we can use the updateAuthDataCfg MBean method. After a data source is used, its contents are instantiated in the server memory and generally cannot be changed.

    For more information about the updateAuthDataCfg MBean method, see the SecurityAdmin MBean documentation under Reference > Programming interfaces > Mbean interfaces.

  6. Test the connection.

    We can test your connection from the data source collection view or the data source details view. Access either view in the dmgr console, and then select a connection from the list. Click Test Connection on the connection. See the topic, Test the connection service.


Related concepts:

Test connection service
JDBC providers
Data sources
Resource reference benefits
Data source lookups for enterprise beans and web modules


Related


Troubleshoot applications with HPEL
Configure a JDBC provider
Configure a data source
Configure a JDBC provider and data source using the JMX API
Manage Java 2 Connector Architecture authentication data entries for JAAS


Reference:

Data source page
Data source (WAS V4) page
JDBC provider page


Related information:

Support and downloads: Technical support search function


+

Search Tips   |   Advanced Search