Change location of hibernate.properties file while using hibernate.cfg.xml

Question

We provide db credential in hibernate.cfg.xml as

<hibernate-configuration>
    <session-factory>
       <property name="hibernate.connection.url">url</property>
       <property name="hibernate.connection.username">username</property>
       <property name="hibernate.connection.password">password</property>
    <session-factory>
<hibernate-configuration>

Either we can provide these properties here or in hibernate.properties in classpath. But I want them to come from an external file. I couldn't find a way in hibernate to change the path of default hibernate.properties file.

Please help.

[EDIT] The method in java which generates sessionFactory object

public class HibernateUtil {

  private static final SessionFactory sessionFactory = buildSessionFactory();

  private static SessionFactory buildSessionFactory() {
    // Create the session factory from hibernate.cfg.xml
    Configuration configuration = new Configuration();
    StandardServiceRegistryBuilder serviceRegistryBuilder =
        new StandardServiceRegistryBuilder().applySettings(configuration.getProperties());
    return configuration.buildSessionFactory(serviceRegistryBuilder.build());
  }

  public static SessionFactory getSessionFactory() {
    return sessionFactory;
  }
}

How are you invoking the sessionFactory in your Java code.? — user2339071
– user2339071, Commented Jul 30, 2014 at 16:39

Ankur Singhal · Accepted Answer · 2014-07-30 17:09:32Z

3

Programmatically, you can load XML and properties like this:

public class MyHibernate {

  private static final SessionFactory sessionFactory = buildSessionFactory();

  private static SessionFactory buildSessionFactory() {
    try {
        URL r1 = MyHibernate.class.getResource("/hibernate.cfg.xml");
        Configuration c = new Configuration().configure(r1);

        try {
            InputStream is = MyHibernate.class.getResourceAsStream("/hibernate.properties");
            Properties props = new Properties();
            props.load(is);
            c.addProperties(props);
        } catch (Exception e) {
            LOG.error("Error reading properties", e);
        }

        return c.buildSessionFactory();
    } catch (Throwable ex) {
        LOG.error("Error creating SessionFactory", ex);
        throw new ExceptionInInitializerError(ex);
    }
  }

  public static SessionFactory getSessionFactory() {
    return sessionFactory;
  }
}

Through Spring

You can use a PropertiesFactoryBean to read-in the properties from your file and configure your LocalSessionFactoryBean:

<bean id="sessionFactory" class="org.springframework.orm.hibernate.LocalSessionFactoryBean">
    <property name="hibernateProperties">
      <bean class="org.springframework.beans.factory.config.PropertiesFactoryBean">
        <property name="location">path-to-properties-file</property>
      </bean>
    </property>
    ...
  </bean>

Hope it be useful.

edited Jul 30, 2014 at 17:09

answered Jul 30, 2014 at 16:55

Ankur Singhal

26.1k17 gold badges92 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aashish Katta Over a year ago

I didn't want to use InputStream class to load hibernate properties, is there a way to include this in spring

Collectives™ on Stack Overflow

Change location of hibernate.properties file while using hibernate.cfg.xml

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related