multiple database with JPA Hibernate without Spring

Question

I have a application with JPA Hibernate without Spring and I need connect to multiple databases (with the same estructure).

The databases will be created for each client, and would have to use the same entity manager. Please I need some idea of how I can do that. I am not using Spring. My application uses MySql, JPA2, Hibernate and JSF.

Thank you!

Istvan Devai · Accepted Answer · 2012-06-29 15:39:37Z

1

If everything is the same, except for dbname/username/pass, then create a persistence.xml with a persistance unit, put everything there which is static.

Then use the following method to create the entity manager:

javax.persistence.Persistence.createEntityManagerFactory(String persistenceUnitName, Map properties);

Supply the variable parameters in the map, like this:

properties.put("hibernate.connection.url", "jdbc:postgresql://127.0.0.1/test");
properties.put("hibernate.connection.username", "joe");
properties.put("hibernate.connection.password", "pass");

answered Jun 29, 2012 at 15:39

Istvan Devai

4,02226 silver badges22 bronze badges

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

1 Comment

fredicini Over a year ago

Your answer is the solution! Thanks!!. My problem was resolved

Collectives™ on Stack Overflow

multiple database with JPA Hibernate without Spring

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