使用WAS 测试数据源报错 Connection fails with error DSRA0010E

摘自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.

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.

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.

重新启动数据库,再测试连接就好了.