How to know underlying database name from hibernate provider

Question

I am using hibernate 3.x with Jboss. Currently we support multiple databases.

Now in runtime, how can I know the underlying database information ? at least name or database-dialect? (e.g. MySQL, Derby, Oracle, etc)?

Can any one suggests any way to find this information? I thought hibernate SessionFactory class will provide such api - but it is not?

Thanks in advance,

Possible duplicate: http://stackoverflow.com/questions/821466/how-can-i-get-the-database-name-i-am-connected-to-through-hibernate — javamonkey79, Dec 04 '10 at 01:55

score 9 · Answer 1 · answered Dec 04 '10 at 01:54

9

I think you can do it this way:

sessionFactory.getCurrentSession().connection().getMetaData().getURL()

answered Dec 04 '10 at 01:54

javamonkey79

17,443
36
114
172

3

Be aware, that this method creates a abandoned connection without closing it. – DanielK Sep 27 '16 at 12:31

score 8 · Answer 2 · edited Nov 26 '14 at 10:48

Thanks very much javamonkey79 and costis for responding to this question.

Yes - I can read the hibernate.properties/cfg.xml file - but I wanted to avoid the file reading workflow.

It appears that Session::connection() api is deprecated now, but it still works. We also can retrieve the same info in another way as listed below.

OPTION 1

Session session = sessionFactory.openSession();
String dbURL = session.connection().getMetaData().getURL().toString();
session.close();

OPTION 2

Settings settings = ((SessionFactoryImpl) sessionFactory).getSettings();
if (settings != null) {
    Connection connection = settings.getConnectionProvider().getConnection();
    String dbURL  = connection.getMetaData().getURL();
    connection.close();
}

For MySql, the return URL will be in form of:

jdbc:mysql://localhost:3306/edm?useUnicode=true

score 4 · Answer 3 · answered Oct 25 '11 at 08:43

sessionFactory.getDialect();

gives you the Dialect and

sessionFactory.getSettings().getConnectionProvider().getConnection().getMetaData().getURL();

provides you the connection url.

Note: This only works with the SessionFactoryImpl class, not with the interface

score 3 · Answer 4 · answered Jun 15 '20 at 22:32

Easiest way is to get the currently configured properties and then get your db URL using key "hibernate.connection.url". The following code prints current session url

System.out.println(sessionFactory.getProperties().get("hibernate.connection.url"))

on my system I get

jdbc:postgresql://localhost:15432/tempdb

score 3 · Answer 5 · answered Jan 20 '12 at 06:01

3

Or you can try:

SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
SessionFactoryImpl sessionFactoryImpl = (SessionFactoryImpl) sessionFactory;
Properties props = sessionFactoryImpl.getProperties();
String url = props.get("hibernate.connection.url").toString();
String[] urlArray = url.split(":");
String db_name = urlArray[urlArray.length - 1];

answered Jan 20 '12 at 06:01

louis xie

1,352
2
12
22

I was hoping this would be a way I could look at all Hibernate properties, but it seems that it only works if the config is being read from the file hibernate.cfg.xml. I am using Spring to configure Hibernate so it doesn't work. Any idea how to access the SessionFactoryImpl that is created by Spring? – Glenn Lawrence Apr 12 '15 at 04:21
1

I figured out that I could get the SessionFactory from Spring like this `(SessionFactoryImpl) appContext.getBean("sessionFactory");` where appContext is my ApplicationContext. Using this I can get lots of properties, but oddly not the *hibernate.connection.url* mentioned in this post. – Glenn Lawrence Apr 12 '15 at 04:47

score 1 · Answer 6 · answered Nov 08 '13 at 05:50

and you can try this code:

String url = null;
try {
    url = getSession().connection().getMetaData().getURL().toString();
} catch (HibernateException e) {
    e.printStackTrace();
} catch (SQLException e) {
    e.printStackTrace();
}
String[] urlArray = url.split(":");
String db_name = urlArray[1];

;)

score 1 · Answer 7 · answered Dec 04 '10 at 01:51

1

Since you have either a hibernate.properties or a hibernate.cfg.xml, you can allways read any information off these files.

answered Dec 04 '10 at 01:51

Costis Aivalis

13,680
3
46
47

score 1 · Answer 8 · answered Aug 08 '18 at 10:06

For Hibernate 5.2.0, to get the datasource..

SessionFactoryImplementor entityManagerFactory = (SessionFactoryImplementor) sessionFactory.openSession().getEntityManagerFactory();
DatasourceConnectionProviderImpl connectionProvider = (DatasourceConnectionProviderImpl) entityManagerFactory.getServiceRegistry().getService(ConnectionProvider.class);
BasicDataSource dataSource = (BasicDataSource) connectionProvider.getDataSource();
dataSource.getUrl();

score 0 · Answer 9 · answered Mar 18 '21 at 00:25

0

You can inspect it in variable view in IntelliJ as below

answered Mar 18 '21 at 00:25

phray2002

425
4
9

score 0 · Answer 10 · answered Jul 20 '21 at 23:02

0

this worked for me:

DataSource dataSource = (DataSource)entityManagerFactory.getProperties()
.get("hibernate.connection.datasource");

Connection connection = dataSource.getConnection();
String databaseName = connection.getCatalog();

answered Jul 20 '21 at 23:02

Ricardo Dias

1

1

Please explain your lines of code so other users can understand its functionality. Thanks! – Simon Pham Jul 21 '21 at 04:56

score 0 · Answer 11 · answered May 23 '23 at 06:06

With Hibernate5 and C3P0 managed connection pool, the following returned me the JDBC URL:

    ((DriverManagerDataSource) 
            ((WrapperConnectionPoolDataSource) 
            ((ComboPooledDataSource) hibernateTemplate.getSessionFactory().getProperties()
                    .get("hibernate.connection.datasource"))
            .getConnectionPoolDataSource())
            .getNestedDataSource()).getJdbcUrl();

How to know underlying database name from hibernate provider

11 Answers11

OPTION 1

OPTION 2

Linked