|
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 |
|
|
|
|
|
|
|