How to get error codes using java program

[kasipandian]

Dear Friends,

My requirement is to get the SQL error code through my program whenever the exception thrown. I've to show this error code in JSP. Now I'm getting a error codes with messages. I'm using spring frame work. So If there any database related exceptions I'm getting DataAccessException . I don't know how to get the error code from DataAccessException to . In SQLException we have a method getErrorCode(). However I'm not getting any SQLException, So I cannot use this. So please help me to get the error code from DataAccessException . Any help would be appreciated.

Thanks
Kasi.

[derrickD]

Doesn't DataAccessException have a getMessage() method??
I use that one and I am pretty sure I have seen the ORA errors on my screen when they occur.

[Eranga]

Can you tel me how did you communicating with your database?

[danielstoner]

Try DataAccessException.getCause(). It should return a cause exception. You can walk the cause chain and maybe you can find the SQLException somewhere in there. The signature is:

public Throwable getCause()

You can check the type of exception with instanceof.

[Eranga]

Yep, but daniel I think it is possible only with JDBC. With Hibernate we can't do it. Correct me if I'm wrong.

[danielstoner]

Honestly I didn't use Hibernate for a while now so I don't remember this detail.

[Eranga]

As far as I remember it's true. I'll check it and let you know. Not now ;)

[kasipandian]

Hi friends
I'm using Spring DAO and getting connection from the server using JNDI look up. I can able to get the error message. However I want to display the error code in the JSP. Is there any way to do it?

Thanks
Kasi.

[derrickD]

I am using struts2 and just catch the error in my action and then display it with an actionError("Error "+e.getMessage());
It is displayed in the jsp then.

[Eranga]

Well explained error message is mush better. Why you guys worried about error codes. ;) There are much better ways to handle exceptions in Java.

[rjuyal]

'm using Spring DAO

If you mean Spring Framework, then

In your DaoImpl, throw the SQLException, pass it to controller via Model ( i guess you have done this already ). In controller catch the SQLexception. use

errors.reject ( "DB Error", new Object[] { new Integer ( sqlException.getErrorCode() ) , sqlException.getCause().getMessage()}, "DB Error: {0} : {1}"  );

you can set this in your messages.properties also.