How to configure multiple datasources using java Hibernate configuration class

Question

We are configuring Hibernate using java, here is our code to configure hibernate.

@Configuration
@EnableTransactionManagement
@ComponentScan({ "org.npcc.ccms.config" })
@PropertySource(value = { "classpath:application.properties" })
public class HibernateConfiguration {
    final static Logger logger = LogManager.getLogger(HibernateConfiguration.class);

    @Autowired
    private Environment environment;

    @Bean
    public LocalSessionFactoryBean sessionFactory() {
        LocalSessionFactoryBean sessionFactory = new LocalSessionFactoryBean();
        sessionFactory.setDataSource(dataSource());
        sessionFactory.setPackagesToScan(new String[] { "org.npcc.ccms.model" });
        sessionFactory.setHibernateProperties(hibernateProperties());
        return sessionFactory;
     }

    @Bean(destroyMethod="")
    public DataSource dataSource() {
        JndiTemplate jndi = new JndiTemplate();
        DataSource dataSource = null;
        try {
            dataSource = (DataSource) jndi.lookup(environment.getRequiredProperty("datasource"));
        } catch (NamingException e) {
            logger.error("NamingException for java:comp/env/jdbc/ccms_cp1_orcl", e);
        }
        return dataSource;
    }

    private Properties hibernateProperties() {
        Properties properties = new Properties();
        properties.put("hibernate.dialect", environment.getRequiredProperty("hibernate.dialect"));
        properties.put("hibernate.show_sql", environment.getRequiredProperty("hibernate.show_sql"));
        properties.put("hibernate.format_sql", environment.getRequiredProperty("hibernate.format_sql"));
        return properties;        
    }

    @Bean
    @Autowired
    public HibernateTransactionManager transactionManager(SessionFactory s) {
       HibernateTransactionManager txManager = new HibernateTransactionManager();
       txManager.setSessionFactory(s);
       return txManager;
    }
}

My question is how can configure another datasource within same hibernate configuration class? I found solution here but using xml configuration, how this works using java configuration? Thanks in advance.

Alex Barnes · Accepted Answer · 2015-09-21 04:34:45Z

2

You will need two different beans annotated as follows:

@Bean(name="SessionFactory")
public SessionFactory sessionFactory() {

}

and:

@Bean(name="OtherSessionFactory")
public SessionFactory otherSessionFactory() {

}

And two datasources configured appropriately.

Then when you want to use the other SessionFactory you just need:

@Autowired
@Qualifier("SessionFactory")
SessionFactory sessionFactory

or

@Autowired
@Qualifier("OtherSessionFactory")
SessionFactory sessionFactory

answered Sep 21, 2015 at 4:34

Alex Barnes

7,2281 gold badge32 silver badges51 bronze badges

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

5 Comments

Ramu Over a year ago

Thanks for you response Alex, i am going to create separate configuration classes for each datasource and separate Transaction Managers with Propagation.REQUIRED in my service.

Alex Barnes Over a year ago

OK. If you have multiple beans of the same type you'll need to use @Qualifier regardless.

Ramu Over a year ago

How to generalize base DAO class? @Autowired @Qualifier("SessionFactory") private SessionFactory sessionFactory; public T getByKey(PK key) { return (T) getSession().get(persistentClass, key); }

Alex Barnes Over a year ago

If you're using @Qualifier I think this is the correct answer ;-)

Ramu Over a year ago

How can we write GenericDAO class with multiple session factories?? Say i have GenericDao class with delete() method which deletes record on session but how to generalize this across other databases. Which mean do we have to create GenericDAO per SessionFactory???? Please advise

Collectives™ on Stack Overflow

How to configure multiple datasources using java Hibernate configuration class

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related