Forums Register Login

DatabaseMetaData

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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)
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Daniel,
Try something like this:

Then you can have CustomerUnsupportedException redirect to an error page or otherwise display a clear message.
Seriously Rick? Seriously? You might as well just read this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1076 times.
Similar Threads
Hibernate: How to tell the DB who is updating data
MySQL table last update
How to determine 1:1, 1:M etc. relationships using DatabaseMetaData
Help
how to get the table constraints?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 06:37:13.