DatabaseMetaData

[Fisher Daniel]

Hi all,
I want to develop an application to retrieve all information about Database Management System.
I use DatabaseMetaData to get those information.
I see all the method on that interface always throw SQLException.
How can I distinguish about SQLException whether it is connection error or that database management system is not supported a feature?

thanks
daniel

[Jeanne Boyarsky]

Daniel,
The exception getMessage() will provide more information. The actual message is database dependent. But you can try it once by hand and see what message your database gives for connection errors. (try turning off the database or pointing at a non-existant database to do this)

[Fisher Daniel]

Hi Jeanne,
I tried my application with Oracle Database.
And some feature is not supported by Oracle, the JDBC driver will throw SQLException with message "Unsupported feature".

Oh.. I am sorry to not describe my application clearly.
My application will display all database's features.
If there is a feature that a database doesn't support so I want my application will display "Not Available".
Because of that I want to know how I can distinguish the error message within SQLException.

Hope this help you to understand my case..
Thank you very much for your attention

daniel

[Jeanne Boyarsky]

Daniel,
Try something like this:

try {
// JDBC stuff
} catch (SQLException e) {
  if ( e.getMessage().contains("Unsupported feature") ) {
    throw new CustomUnsupportedException();
  } else {
    throw e;
  }
}

Then you can have CustomerUnsupportedException redirect to an error page or otherwise display a clear message.