[Version 5.0.2 and later]Verifying a connection

Why and when to perform this task

Many test connection problems can be easily fixed by verifying some configuration parameters This article provides a checklist of steps that you must complete to enable a successful connection. Click on the link for more information on a specific step.

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.

Steps for this task

  1. Create the authentication data alias.
  2. Create the JDBC provider.
  3. Create a Version 5.0 or 4.0 data source.
  4. Save the data source.
  5. Restart the server.

    If you are running Websphere Application Server Version 5.0.2, you do not have to complete this step unless you also created a new Java Authentication and Authorization Service (JAAS) entry.

  6. Test the connection

    You can test your connection from the data source collection view or the data source details view. Access either view in the administrative console, and then select a connection from the list. Click the test connection button on the connection.

    You must complete all the steps and restart the server before you test the connection. Neither the authentication data alias nor the WebSphere Application Server environment variables (in Version 5.0.1) are available before a server restart.


Related concepts
Test connection
JDBC providers
Data sources
Looking up data sources with resource references for relational access
Binding to a data source
Related tasks
Creating and configuring a JDBC provider using the administrative console
Creating and configuring a data source using the administrative console
Creating a JDBC provider on multiple nodes
Creating and configuring a JDBC provider and data source using the Java Management Extensions API
Related reference
Data Source collection
Data Sources (Version 4)
JDBC Provider collection



Searchable topic ID:   verifycon
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/ae/tdat_verifycon.html

Library | Support | Terms of Use | Feedback