SQLException e 1

[jetec]

Is there a way to interpret exceptions? For example, if I want an ORA-00001 to display a message?

if(e=="ORA-00001")
{
out.println("Constraint violation!");
}

 

[sedj]

I would never attempt to interpret the meaning of an exception based on the message in that exception ... however, if you HAD to do it :

try {
   // stuff
} catch (SQLException sqle) {
   String message = sqle.getMessage();
   if (message.indexOf("ORA-00001") != -1) {
      out.println("constraint violation");
   } else {
       out.println("some other ORA error");
   }
}

You cannot do what you posted because of two reasons :

1) Its not valid Java syntax (string equality is not done using '==', but with the 'equals()' method.
2) JDBC and exception handling is not tied to a specific database (such as Oracle).

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[jetec]

Thanks! This is what I needed!