wood burning stoves 2.0*
The moose likes JDBC and the fly likes How to get Username and password automatically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to get Username and password automatically" Watch "How to get Username and password automatically" New topic
Author

How to get Username and password automatically

Ramesh Shanmugam
Ranch Hand

Joined: Sep 13, 2004
Posts: 132
I need to connect to the database. i want to get the username and password from the DSN and then use in my program. how can i do that?


Ramesh Shanmugam - SCJP 1.5
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

What database type? How are you configuring your Data Source Name?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Jyothi Lature
Ranch Hand

Joined: Oct 31, 2001
Posts: 60
Iam not very clear with your question... my understanding is, you want to connect to the db using DSN (which has userid and password given) and then later get the username in your code after getting connected.

For this, you have to connect using the syntax:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String dsn = "DSN_NAME";
String url = "jdbc dbc:" + dsn;
Connection con = DriverManager.getConnection(url);


To get the username in your program after getting connected to the db, you can use getUserName() of DatabaseMetaData interface.

Hope this is what you wanted...


Jyothi<br />Sun Certified Java Programmer<br />Brainbench Certified for Javascript
Jyothi Lature
Ranch Hand

Joined: Oct 31, 2001
Posts: 60
ALternatively,
you could even use a Java properties file, say connect.properties, that helps you to set up your database connection at runtime.
It could have the following parameters in the form of name/value pair:

url=your_URL_here
# User name and password
user=scott
password=tiger

Then, after registering the driver, you could get these parameters from properties file to establish connection and as well have the userid/password available in your program code.
Ramesh Shanmugam
Ranch Hand

Joined: Sep 13, 2004
Posts: 132
Thanks Jyothi Lature

This is what i wanted to know
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to get Username and password automatically
 
Similar Threads
applet
Security Identity in JMS
not able to read the mails
Help:: how can I do the base64 encoding?
Help! What Is HTTP authentication()?