Get the hostname from a DataSource class

java database-connection datasource hostname
Ron picture Ron · Jun 14, 2011 · Viewed 17.5k times · Source

Is there a way to get the hostname from the DataSource class in java? I mean, I have a DataSource object (DS), which is annotated to get the Jboss datasource. Anyway, I want to get the hostname used in that DS.

Debugging, i can see it this way: I get the Connection from DS, then I get the DataSourceMetaData and inside of that the is something called Protocol Connection which have the hostname, but I don't know how to get it.

Anyone here knows how? or another way to get the hostname? Thanks in advance. Kind regards, RDAM

Answer

Suraj Chandran picture Suraj Chandran · Jun 14, 2011

Once you have the DatabaseMetaData, just call the getURL() method which should contain the hostname like so:

dataSource.getConnection().getMetaData().getURL();

Related questions

jboss wildfly datasource connection failing - No managed connections available within configured blocking timeout

I have a jboss wildfly server connected to a mysql database via a datasource configured on the app server. It hapens some time that the mysql database is not accessible for an amount of time (netework problem etc...), when the …

Read More
How do I find out my MySQL URL, host, port and username?

I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don't remember my username. And for connectivity with JDBC, I need the URL, host and port number. …

Read More
Warning about SSL connection when connecting to MySQL database

With the two classes below, I've tried connect to a MySQL database. However, I always get this error: Wed Dec 09 22:46:52 CET 2015 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must …

Read More