hibernate multiple databases

Question

Hi,

What is the best way to support multiple databases using hibernate?

I see the following article... https://www.hibernate.org/429.html

It seems Shards is a possible solution, though the con mentioned is that it's not appropriate for large numbers of schemas.

My requirement, is that we have many different databases, multiple databases for clients as well as for functionality. What would be the best approach using Hibernate that would be performent?

Answer 1

I don't understand the question. Are they all being accessed from a single application?

Answer 2

I have the same question. Let me show the stage:

I have 2 databases, one is oracle, another is sql server. I must connect to oracle using 10 oracle users, 1 user for sql server.

Then what should I do, if I use hibernate?