How to differentiate SQL-Exceptions?

[frag]

Hello everybody!

I have a JSP-page on which I try to connect to a database (sybase). If an exception is thrwon an error-page is called.

What I now try to do is to set a session-attribute depending
on the sql-exception. But I don't know how to differentiate this. I need to know whether the login-informations (username or password) have been wrong or if the database was unreachable or if the user hasn't got the right to access a certain table.

All I am able to do is to print out the exception with:
<% out.println( exception.toString()); %>

But what I want is something like:

String error = &quot;&quot;;

if (exception = <wrong-login-info>){
error = &quot;wrong username or password&quot;;
}
else if (exception = <db-offline>){
error = &quot;database seems to be offline&quot;;
}
else if (exception = <no-rights>){
error = &quot;no rights for the table&quot;;
}
else{
error = &quot;unexpected exception&quot;;
}

Any ideas??

Cheers

frag patrick.metz@epost.de

 

[Tarwn]

I haven't used JSP in a while so forgive my ignorance if I say anything blatently foolish, but:
couldn't you get 2 or three keywords/phrases per error, such as the error number, etc and do an indexOf check?
Pseudocode:

String excepThrown = exception.toString();
if( (exceptThrown.indexOf("incorrect login") >= 0) && (exceptThrown.indexOf("err # here") >= 0)){
   error="wrong username or password"
}
else...

So what you can do is choose a couple unique keywords from the error messages that will only appear for each specific error.

-Tarwn
--- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[frag]

Hi Tarwn,

this was my first thought too. But actually I hoped that
there is a 'nicer' solution to this.

Thanx for your answer.

frag patrick.metz@epost.de

 

[Tarwn]

I'm not sure if you can, the general exception only has a cause (throwable) and the error, available as a string. Perhaps I'm not hinking sneeky enough today, but I don't see an alternative route on this.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html