Test Connection fails with error DSRA0010E
 Technote (FAQ)
 
Problem
Test Connection fails on data source which has newly created J2C Authentication Alias.
 
Cause
After configuring the data source, click the Test Connection button from Administrative Console gets the following error:
The test connection operation failed for data source [datasource] on server nodeagent at node [node] with the following exception: java.lang.Exception: java.sql.SQLException: null userid not supported
DSRA0010E: SQL State = null, Error Code = -99,999. View JVM logs for further details.
This error often occurs after a new J2C authentication alias was created or an existing one was modified. The configuration change for the new authentication alias was not pushed out to the Java™ process in which the Test Connection was invoked on.
 
Solution
The problem can be easily solved by restarting the Java process (application server, node agent or deployment manager) for which the Test Connection is running based on the following:
  • In the IBM® WebSphere® Base environment, there is a single Java process running. The Administrative Console runs in this process, and Test Connection operation for the data source takes place in this process as well.
  • In the WebSphere Network Deployment environment, the Test Connection operation for data sources configured at the server level is performed in the node agent of that server. The data source configured at the node or cell level is performed in the node agent or deployment manager servers respectively.
If server restart cannot be done, see the following for another possible solution: http://www.ibm.com/support/docview.wss?uid=swg24009485
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Application Servers Runtimes for Java Technology Java SDK
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): Windows
Software version: 5.1.1
Software edition:
Reference #: 1235300
IBM Group: Software Group
Modified date: Apr 14, 2006