to retrieve database username and password using jdbc

[siva sankar]

Hi,
It is easy to get connecting to any database using username and password which is already known to us,

eg: Class.forName("org.postgresql.DriverManager");
Connection con = DriverManager.getConnection("jdbc:postgresql://URL","infinity","infinity");

please help me how to print the username and password which is used in getting connection(Connection class).
Please specify the method to retrieve those values.
Thanks In Advance
siva sankar

[Paul Sturrock]

How do you connect to a database without already knowing these? Or are you asking how to query the credentials of a particular database user other than the one you connected with?

[Scott Johnson]

Are you saying that you have an open Connection object and you want the username and password that were used when opening the connection?

There are no standard methods on the Connection object or DriverManager that will provide that. I scanned the Postgresql driver javadoc and didn't see a Postgresql-specific method either.

You'll need to get it from whatever object gave it to the DriverManager.

[Jeanne Boyarsky]

Siva,
I can't imagine that there would be a public API to get the password. This would mean that any code with access to a connection or datasource could get the user's credentials. I think you will have more luck intercepting this information from where the connection is created.

If you explain further what you are trying to accomplish, you may get a more useful answer.