Hello,

it looks like from the post on this forum that union won't be supported in HQL because it's not OO. I have a use case to submit.

I have a data model looking (in a simplified way) like the following:


In my application someone is looking, at an instance of F and wants to see a set of object A. The set of object A is computed as the union of 2 queries going through the BC path for one and through the DE path for the others.

So I'm wondering how I can do this in an efficient way. Sure I can get all the objects from one path and the from the other and compute the set (but loading 1000 objects is not really efficient) or make some complex query ... Or maybe there is a proper hibernate way of doing things ?

Guillaume