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

Question

For this Connection an example is how to find out the URL that Connection uses to connect the database? Is it somewhere in the Properties returned by Connection.getClientInfo() ?

If you need me to give a clearer description, all comments are welcome. Thanks you

Answer 1

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

Answer 2

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

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

Answer 3

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 code example.

And here is the object documentation: DatabaseMetaData Interface

Answer 4

connection.getClientInfo () has all the information related to the connection. It returns a property object. You can get the value of the password property to get the password that was used for the connection object.

Please let me know if this solves your problem.