How can I get sql server database name from DatabaseMetaData object

Question

I am wondering how can I get the database instance name from DatabaseMetaData, or is there any way I can do that, kind of stuck here, thanks for any pointers!

How to get sqlserver database name from datasource name in Java

Even

Could you please clearify what you would like to achieve? It is a little unclear to me what you mean by "database instance". I assume you've got the DatabaseMetaData via the Connection, which represents a connection to the database. You can do all the manipulation you'd like on the database via the Connection instance. However, it is unclear to me what you would like to achieve? — sbrattla
– sbrattla, Commented Aug 19, 2011 at 9:44
possible duplicate of How to get sqlserver database name from datasource name in Java — KV Prajapati
– KV Prajapati, Commented Sep 26, 2011 at 7:12

ashario · Accepted Answer · 2017-02-21 23:01:21Z

0

Once you've obtained a database connection:

// url is usually in the format jdbc:mysql://<ip address>:<port>/<database name>    
String url = theConnection..getMetaData().getURL();
String databaseName = StringUtils.substringAfterLast(url, "/");

The above code uses StringUtils in Apache Commons Lang 3

answered Feb 21, 2017 at 23:01

ashario

2,7422 gold badges25 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I get sql server database name from DatabaseMetaData object

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related