摘自http://www-01.ibm.com/support/docview.wss?uid=swg21235300
Problem(Abstract)
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.
Resolving the problem
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 Application Server 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.