WebSphere Application Server Network Deployment, Version 6.1
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

             Personalize the table of contents and search results

Testing a connection with the administrative console

After you have defined and saved a data source, you can click the Test Connection button to ensure that the parameters in the data source definition are correct.

Before you begin

[z/OS] Restriction: In a network implementation of WebSphere Application Server, you cannot test connections for the following data sources at the node level. You can create node-level configurations of the data sources for application use; these configurations work properly at runtime. However, to successfully run TestConnection on the following data sources, test at the server level only.
  • DB2 Universal JDBC Driver Provider data source with driver type 2
Application Server issues the following exception for TestConnection at the node level:
java.sql.SQLException: Failure in loading T2 native library db2jcct2DSRA0010E: SQL state = null, Error Code = -99,999
Both data sources are based on type 2 JDBC drivers, which need access to the T2 native library. The WebSphere Application Server runtime provides that access for node-scoped data sources. The test connection service, however, does not provide access to the native files at the node level. Therefore, when you create these data sources at the node scope, create the same configurations at the server scope for testing purposes. Run the test connection operation at the server level to determine if the data source settings are valid overall.

About this task

You can select multiple data sources on the data source collection page and test them as a group. Be sure that the following conditions are met before using the Test Connection button:

Procedure




In this information ...


Related concepts

IBM Redbooks, demos, education, and more


Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

IBM Suggests
Task topic    

Terms of Use | Feedback

Last updated: Feb 25, 2009 9:32:38 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.nd.multiplatform.doc/info/ae/ae/tdat_testcon.html