Tuesday, March 16, 2010

WAS - Datasource connection failed

Solution For - Websphere Application Server - Datasource test connection operation failed
The test connection operation failed for data source opstar on server server1 at node LHX00CND84324PVNode02 with the following exception: java.sql.SQLException: invalid arguments in callDSRA0010E: SQL State = null, Error Code = 17,433. View JVM logs for further details.

Solution::
1. Go to websphere admin console
2. Under Security >> Secure administration, applications, and infrastructure >> JAAS >> J2C authentication data
3. Click New
4. Enter alias name
5. Enter Data base user id and password for connecting to database.
6. Click OK.

No comments:

Post a Comment