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

最新推荐文章于 2023-07-07 16:04:37 发布

原创最新推荐文章于 2023-07-07 16:04:37 发布 · 7k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#测试 #authentication #deployment #websphere #application

401DB 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了在使用WebSphere Application Server Base环境配置数据源并创建或修改J2CAuth认证别名后，测试连接时出现nulluserid不支持错误的原因及解决方案。通过重新启动相关的Java进程即可轻松解决此问题。

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

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