how to modify hibernate.cfg.xml at runtime?

[Piyush Patel]

hello Experts,
how do i edit database's username and password at runtime ? (sometimes IP address also may change)..
for this i need to edit hibernate.cfg.xml file ..
below i smy hibernate.cfg.xml 's details.

     <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/p1</property>
    <property name="hibernate.connection.username">piyush</property>
    <property name="hibernate.connection.password">a1234</property>

thanks 4 your time !
help

[Karthik Shiraly]

Hi Piyush,

Since IP/credentials are not static, I feel they shouldn't be in a configuration file at all. Instead, some component which tracks current database IP/credentials should respond to changes by closing the current SessionFactory, create a new Configuration object programmatically, and create a new SessionFactory from that. Rest of the components should start using this new SessionFactory.

Programmatically modifying the xml file and reloading it is unnecessarily complicated, since the goal is just to change the active Configuration.

Cheers
Karthik

[Karthik Shiraly]

Ok, on 2nd thoughts, you can use a mixed approach, since only few of the properties change at runtime, while the rest of the Configuration remains same. So do use a configuration file, but when there's runtime change, use the 'Configuration.setProperty()' method to change values. You still need to close the old SessionFactory and create a new one. But you can use the same Configuration object.

[David Newton]

I'm curious what kind of setup would ever require this to change at runtime.

[David Lee Lambert]

David Newton wrote:I'm curious what kind of setup would ever require this to change at runtime.

I'm running into this issue. Trying to write a utility in Java that reads a file in a certain format and loads it into the database used by a certain content-management system. The mapping files mirror the CMS's own standard structure, so they shouldn't change, and the CMS generally only runs with MySQL as the database, but the server, schema, username and password could be anything.

I've built a Swing-based wizard to collect that information and also have a class that collects it from the command-line. I'm trying to patch it in as follows:

         Configuration hibConfiguration = new Configuration();
         hibConfiguration.setProperty("connection.url", "jdbc:mysql://"+hostname+"/"+database);
         hibConfiguration.setProperty("connection.username", username);
         hibConfiguration.setProperty("connection.password", password);
         hibSessionFactory = hibConfiguration.buildSessionFactory();

However, I still get the log-message

INFO: using driver: com.mysql.jdbc.Driver at URL: * set in app *

followed by the error

SEVERE: No suitable driver
Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Cannot open connection
...
Caused by: java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:320)

So I'd be interested in a good answer to this question as well.

[David Newton]

That seems like a classpath issue.

[Carlos Oviedo]

I'd like to know if someone have a solution for this idea? because I need to do the same, modify the property "connection.password" in hibertate.cfg.xml at runtime, firstly this password is encrypted in my xml and then I have to decrypt it. Actually I have the classes to do that, only I need this part! How can I do this? Some Ideas?

In advance thank you very much.

[Carlos Oviedo]

Carlos Oviedo wrote:I'd like to know if someone have a solution for this idea? because I need to do the same, modify the property "connection.password" in hibertate.cfg.xml at runtime, firstly this password is encrypted in my xml and then I have to decrypt it. Actually I have the classes to do that, only I need this part! How can I do this? Some Ideas?

In advance thank you very much.

I find the solution to my case!!!

I modified in my code this part:

cfg.setProperty("connection.password", dp.getDescifrar());

to this:

cfg.setProperty("hibernate.connection.password", dp.getDescifrar());

"hibernate." is very important in the properties.


Page helped me:
http://stackoverflow.com/questions/1341871/hibernate-configuration-on-runtime