This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DatabaseMetaData

 
Fisher Daniel
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 582
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Daniel,
Try something like this:

Then you can have CustomerUnsupportedException redirect to an error page or otherwise display a clear message.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic