How to connect to multiple databases in Hibernate

by

Using annotation mappings as an example:

Configuration cfg1 = new AnnotationConfiguration();
cfg1.configure("/hibernate-oracle.cfg.xml");
cfg1.addAnnotatedClass(SomeClass.class); // mapped classes
cfg1.addAnnotatedClass(SomeOtherClass.class);
SessionFactory sf1 = cfg1.buildSessionFactory();

Configuration cfg2 = new AnnotationConfiguration();
cfg2.configure("/hibernate-mysql.cfg.xml");
cfg2.addAnnotatedClass(SomeClass.class); // could be the same or different than above
cfg2.addAnnotatedClass(SomeOtherClass.class);
SessionFactory sf2 = cfg2.buildSessionFactory();

Then use sf1 and sf2 to get the sessions for each database. For mapping files, you just use cfg.addClass instead of addAnnotatedClass. Put the cfg.xml files in the root package in this case. Those will have the Oracle or MySQL dialect and connection information.

More Related Contents:

  1. How to do bulk (multi row) inserts with JpaRepository?
  2. How to generate Custom Id using hibernate while it must be primary key of table
  3. hibernate: LazyInitializationException: could not initialize proxy
  4. Criteria.DISTINCT_ROOT_ENTITY vs Projections.distinct
  5. Why is HibernateDaoSupport not recommended?
  6. How to mix inheritance strategies with JPA annotations and Hibernate?
  7. How do you create a Distinct query in HQL
  8. Hibernate saveOrUpdate behavior
  9. Filling combobox from database by using hibernate in Java
  10. Why do I need to configure the SQL dialect of a data source?
  11. JPA 2.0 : Exception to use javax.validation.* package in JPA 2.0
  12. How to import initial data to database with Hibernate?
  13. How to integrate spring with hibernate session and transaction management?
  14. how to return Map with HQL
  15. JPA 2.0: Adding entity classes to PersistenceUnit *from different jar* automatically
  16. hibernate could not get next sequence value
  17. How to disable hibernate caching
  18. Save child objects automatically using JPA Hibernate
  19. Grails 2.4 and hibernate4 errors with run-app
  20. Hibernate/JPA ManyToOne vs OneToMany
  21. Spring Boot + JPA2 + Hibernate – enable second level cache
  22. Light weight alternative to Hibernate? [closed]
  23. Hibernate Criteria Restrictions AND / OR combination
  24. hibernate connection pool
  25. Hibernate, spring, JPS & isolation – custom isolation not supported
  26. Date operations in HQL
  27. Hibernate hbm2ddl.auto, possible values, and what they do
  28. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  29. Using hibernate criteria, is there a way to escape special characters?
  30. Should Hibernate be able to handle overlapping foreign keys?

Leave a Comment