Java and hibernate one application separate databases

Question

I have been trying to find a solution but with no luck.

I have an Java application (Tapestry) and Hibernate to connect to database. Now there are 3 companies that want to use the same instance of application but different database.

What I have to do is depending on company that accesses the app use different database.

Possible duplicate of How to setup Hibernate to read/write to different datasources? — XtremeBaumer
– XtremeBaumer, Commented Nov 11, 2019 at 14:13

Stanley Mungai · Accepted Answer · 2019-11-11 14:13:36Z

0

You can load different config Files in Hibernate Depending on the company. Just have the Hibernate Config files in Different location per company and configure session from different databases using:

File f = new File("C:\\company_name\\hibernate.cfg.xml");

SessionFactory sessionFactory = new Configuration().configure(f).buildSessionFactory();

answered Nov 11, 2019 at 14:13

Stanley Mungai

4,15030 gold badges103 silver badges172 bronze badges

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

2 Comments

user3175322 Over a year ago

i tried when user logs in get companyParameter and depending on that load companyParameter+hibernate.cfg file but somehow somewhere on startup still it searches for the default hibernate.cfg --------------- Configuration cfg = new Configuration().configure(companyParameter+"hibernate.cfg.xml");

Stanley Mungai Over a year ago

@user3175322 You are passing a String into configure(string) method. The expectation is that the String is in classpath. Please pass a File parameter as in the example I have given above.

Collectives™ on Stack Overflow

Java and hibernate one application separate databases

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related