Variables in hibernate.cfg.xml

aukemid · **Joined:** Wed Mar 10, 2010 4:48 am **Posts:** 106

In my config file I have this:

Code:

<property name="hibernate.connection.url">jdbc:mysql://IP:PORT/DB_NAME</property>

Can I make IP variable? and can I set this variable in my java main?

harshagiri · **Joined:** Sat Mar 27, 2010 2:43 am **Posts:** 8

yes you can use the IP address instead of the computer name
like localhost by 127.0.0.1 and then the service name or DB name which
like 127.0.0.1/service

And are you asking that you need to set this varaible in

Code:

public static void main ( String args[] )
{
...
}

In the above code?

aukemid · **Joined:** Wed Mar 10, 2010 4:48 am **Posts:** 106

I quess I wasn't clear.

Now I have something like this:

Code:

<property name="hibernate.connection.url">jdbc:mysql://192.168.0.2:3306/db</property>

In stead of 192.168.0.2 I want to use a variable, which I will set before the hibernate.cfg.xml file is used.

harshagiri · **Joined:** Sat Mar 27, 2010 2:43 am **Posts:** 8

yes you can use the IP address instead of the system name.

And as far as the editing some file which will be having this details, yes you can edit that file and set whatever value you want. For that you need to open that particular file, traverse till the particular property and change the machine name to the respective IP address.

aukemid · **Joined:** Wed Mar 10, 2010 4:48 am **Posts:** 106

I have this working now.
I use a BufferedReader and a BufferedWriter to modify the url in the hibernate.cfg.xml file.
The problem is that Hibernate reads the config file before I modify it.

Does anyone knows when the config file is read or is modifying not possible after compilation?

sanne.grinovero · **Posted:** Wed Jun 02, 2010 5:20 am

Hi the usual way people do this is by using ANT filters or Maven profiles to replace some tokens depending on deployment target (test/production/...) in the configuration files.

If you need something more flexible, you don't need to have a hibernate.cfg.xml file at all, you can create the configuration instance programmatically: new Configuration() and then set the properties on it. You could read almost all properties from a properties file, and add some dynamically reading environment variables or program arguments.

aukemid · **Joined:** Wed Mar 10, 2010 4:48 am **Posts:** 106

Thanks a lot.

I do it now using:

Code:

Configuration config = new Configuration();
config.setProperty("hibernate.connection.url", "jdbc:mysql://" + SystemConfig.URL);
config.setProperty("hibernate.connection.username", SystemConfig.USERNAME);
config.setProperty("hibernate.connection.password", SystemConfig.PASSWORD);
sessionFactory = config.configure().buildSessionFactory();

sanne.grinovero · **Posted:** Wed Jun 02, 2010 6:04 am

cool.
FYI there are some useful extensions of Configuration, like AnnotationConfiguration and EJB3Configuration.