First of all I would like to say hello to everyone. This is my first post here. Hibernate is an awesome project.

Anyways, I would like to ask if anyone has done something similiar, has ideas or knows a solution.

The task was to do a search that consumes different databases. The database-entities contain different information that will be listed in a search. So what I did was I created multiple EntityManagers and created multiple search-queries one for every database. So when a query is made with an EntityManager you can only query Entities in that current database.

What I have now is multiple ResultLists and combining them seems to be hard without breaking the hibernate Sorting. So currently I'm just merging multiple object-lists and using Collections.sort() to sort all the minor list into a one final search result that gets printed out.

Might there be any possibilities to query for Entities from different databases in single query?

Any other solutions are also being accepted.

Hope that made any sense.

Best regards,
Matias

Hi,
As per my knowledge, i have not seen such cases where querying to the multiple tables is done using Hibernate(may be i have a very small career with hibernate).

I can tell you a work around for this. You may follow the below steps:

1. Create the view of the other database tables to a single database tables(you can use database links to do so).
2. Create POJOs for the tables(which, i guess, would already be present as you are able to query those tables).
3. As now all the tables exist in the same database(as database views), you may use a single query to query all the tables at once.

Remember, do not drop the tables while creating the hibernate session factory.

Regards,
Keshav