separate read and write databases with hibernate

Question

With hibernate, I want to be able to support multiple databases, one for read and one for writes.

Is this possible? Is the only way to create 2 separate session objects?

Adeel Ansari · Accepted Answer · 2013-02-28 02:17:14Z

2

You answered your first question by your 2nd question. So, now for your second question. Yes, of course you will need separate sessions. Better say, you need several session factories for to support multiple database.

Hibernate: Managing multiple databases and schemas.

For more, look into Hibernate Shards. Shard might not sound like a good idea, because it requires one session factory per database schema. And here I found the relevant thread at JavaRanch Forum.

edited Feb 28, 2013 at 2:17

answered Jan 15, 2010 at 2:05

Adeel Ansari

39.9k12 gold badges98 silver badges135 bronze badges

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

1 Comment

B T Over a year ago

dead link "Hibernate: Managing multiple databases and schemas"

Collectives™ on Stack Overflow

separate read and write databases with hibernate

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