Programmatically override settings specified in config

dru · **Joined:** Mon Mar 24, 2008 12:33 pm **Posts:** 3

Hello.

I need to programmatically override "default" settings, specified in hibernate.cfg.xml. For example, I have:

...
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/db1</property>
<property name="connection.username">user</property>
<property name="connection.password">pass</property>
<property name="connection.useUnicode">yes</property>
<property name="connection.characterEncoding">utf8</property>
...

I want to set in runtime another connection.url. I do next:

Configuration configuration = new Configuration()
.configure()
.setProperty("connection.url", "jdbc:mysql://192.168.2.1/db1");
sessions = configuration.buildSessionFactory();

But hibernate uses values from hibernate.cfg.xml. How can I solve this problem?

ramnath · **Posted:** Fri Jun 13, 2008 4:08 pm

Look into this for directions...

http://forum.hibernate.org/viewtopic.ph ... 5dec715b73

Cameron McKenzie · **Posted:** Sat Jun 14, 2008 9:30 am

This should be as simple as doing something like this:

Code:

Configuration configuration = new Configuration();
configuration.setProperty("hibernate.connection.driver_class", org.hsqldb.jdbcDriver.class.getName());
configuration.setProperty("hibernate.connection.url", "jdbc:hsqldb:abc:123");
configuration.setProperty("hibernate.connection.username", "sa");
configuration.setProperty("hibernate.connection.password", "");
configuration.setProperty("hibernate.dialect", "net.sf.hibernate.dialect.HSQLDialect");
Session session = configuration.buildSessionFactory().openSession();

However, you must not call configure on the configuration object before setting the properties. You do it after. This works equally well with the annotationconfiguration object.