How do I get a full join of two tables unrelated from Hibernate perspective.

I have a requirement to join two tables not mapped with hibernate. I want something like:


is a list of Object[]. Object[1] should be null when it does not have a link and viceversa.

I guess I can do a left/right outer join using "NOT EXIST" clause.
But in this case, I end up executing 3 queries (1 inner join, 1 left, 1 right), with the same where condition.

Hibernate has currently no support for using the JOIN keyword with unrelated classes. However, as long as you don't need a left or right join the following will work:

Ok, I guess my last post didn't add very much since the question was about a full join which includes both a left and right join. The short answer is that this is not possible. However, I think some work has been done on this and may be included in a future Hibernate version. See http://opensource.atlassian.com/project ... wse/HHH-16 for more information.