File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Error Connecting To DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic

Error Connecting To DB2

Prema Durai

Joined: Aug 27, 2009
Posts: 10
While connecting to db2 from the WAS admin console , following error occurs:

The test connection operation failed for data source Agcy Dwld DS on server server1 at node cvdxe106429-027Node04 with the following exception: java.sql.SQLException: DB2 SQL error: SQLCODE: -5042, SQLSTATE: , SQLERRMC: ;1208;N4EACE ;TDH1;QDB2; ; ; ;1208; ;DSRA0010E: SQL State = , Error Code = -5,042. View JVM logs for further details.

How could this be resolved
Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

Prema, you already posted this question in the Websphere forum. One copy of a question is enough. I'm closing this.
I agree. Here's the link:
subject: Error Connecting To DB2
Similar Threads
DB2 SQL error: SQLCODE: -8002
Problem while connecting to db2
Problem connecting to DB2 using Squirrel Database Client
error clarification
Problem while connecting to db2