CODEWITHSUNDEEP
javajdbcconnection-string
Rasto
Rasto

Reputation: 17844

How to get database url from java.sql.Connection?

For given Connection instance how do I find out url that the Connection uses to connect the database ? Is it somewhere in Properties returned by Connection.getClientInfo() method?

If there you need me to provide clearer description all comments are welcome. Thank you

Upvotes: 62

Views: 72361

Answers (4)

Mehdi
Mehdi

Reputation: 367

Inside the Connection object, you have an object of type DatabaseMetaData, it contains a lot of information about the database.

Lucas de Oliveira gave you a good example of code.

And here is the documentation of the object : Interface DatabaseMetaData

Upvotes: 3

Lucas de Oliveira
Lucas de Oliveira

Reputation: 1632

I believe you can use the DatabaseMetaData object from the Connection and then get the URL. Try:

DatabaseMetaData dmd = connection.getMetaData();
String url = dmd.getURL();

Upvotes: 30

Amit
Amit

Reputation: 9

connection.getClientInfo() has all the details related to connection. It returns a properties object. You can retrieve the value of "password" property to fetch the password that was used for the connection object.

Please let me know if this solves your problem.

Upvotes: -1

Ken Chan
Ken Chan

Reputation: 90517

Connection has the getMetaData() to return DatabaseMetaData . DatabaseMetaData has the getURL() to return the URL for this DBMS.

Upvotes: 105

Related Questions