Question
How to get the DB errors from Exception and separate into sqlcode and error description
I have a requirement where, if user provides invalid data, we need to capture the SQL error produced by the invalid data and show back to user.I want to capture the SQLCODE, MSGCODE returned by the SQL error. How can i achieve and show the message back to user
***Updated by Moderator: Vidyaranjan. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option***
i am using RDB-List to make the SQL call, how do i catch that exception and see if there is any. I cant find anything in the clipboard. But when tracing i can see the SQL code and error message
Accepted Solution
Figured it out. I have to use this in the following in the Java Step to get the message
String pageErrorMessage = tools.getActivityStatus().getWorstMessage();
From SQLException, you can try calling getErrorCode() or getMessage() to see if the return value is what you are looking for.
http://docs.oracle.com/javase/6/docs/api/java/sql/SQLException.html