Database name

[diamonddragon]

I have connection to mySQL database through JDBC, and need database name.

Say databaseURL is:

jdbc:mysql://localhost:3306/test

Only way I have found till now is to extract database name from databaseURL, like this:

String databaseName = connection.getMetaData().getURL().substring
                    (connection.getMetaData().getURL().lastIndexOf('/') + 1);

Is there a way to get database name on some other way, using DatabaseMetaData, because I just can not find such method?

[eRaaaa]

I am not sure why you need that?

Is there a way to get database name on some other way

Sure, e.g. with native select query, --> "SELECT DATABASE();" on mysql or SELECT DB_NAME() on sql server, but

using DatabaseMetaData, because I just can not find such method?

I think that getURL is the only possibility

[diamonddragon]

I am not sure why you need that?

Sure, e.g. with native select query, --> "SELECT DATABASE();" on mysql or SELECT DB_NAME() on sql server, but


I think that getURL is the only possibility

Does it mean DatabaseMetaData doesn't have database name value?

[Tolls]

As eRaaa asks, why do you need it?
I'd have thought you'd know what db you were looking at...

[diamonddragon]

As eRaaa asks, why do you need it?
I'd have thought you'd know what db you were looking at...

Well I was experimenting with some example that connects to database using fixed URL.
Later in that application, I was using database name parameter for something, so I have choice to extract database name from fixed URL, or to obtain it from DatabaseMetaData.
Or, as another poster says, to query database.