File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes verify database use_id and password Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "verify database use_id and password" Watch "verify database use_id and password" New topic

verify database use_id and password

Artemesia Lakener
Ranch Hand

Joined: Jun 21, 2005
Posts: 162
I want to write a very simple GUI asking user to input his/her database uid and pwd. If the login is accepted or rejected, they will see the corresponding pages. Just wondering how to check if the uid/pwd for database is correct ? just try to build a database Connection using the GUI's input uid/pwd ? and if there is no SQLException then it is ok, or it fails ? But it seems SQLException can be caused by other database problem other than incorrect uid/pwd... How to exactly check if the uid/pwd is correct ?

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

You will have to parse the exception I'm afraid. Each DB returns a consistant error message for an authentication failure, and SQLExceptions just repeat the content of that error. So for each DB you use this with you will need to watch out for the appropriate error message.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: verify database use_id and password
jQuery in Action, 3rd edition