how to use left joins with unrelated entities in hibernate

Since Hibernate 5.1 you can do this:



Before 5.1, you could do equijoins (INNER JOINS) like this:

Before 5.1, you could do it like this:
select ...
from FinancialRecord f, User u
where
r.lastUpdateBy = u.username


The above query is inner join .

select ...
from FinancialRecord f
left join User u
on r.lastUpdateBy = u.username

The above query is not working in Hibernate 3.x

Hibernate 3.x or 4.x are no longer supported, so you should upgrade to 5.x.

Is Hibernate Support nvarchar type?

Yes, it does. And a lot more.

How to use nvarchar type in hibernate?

and what is the procedure?

Did you read the User Guide and still couldn't find the answer to your question?

Hi Vlad!
Is joining unrelated entites supported by type safe criteria queries also?
I could not find any hint in http://docs.jboss.org/hibernate/orm/5.2 ... l#criteria so I assume not!?

thomas

I haven't tested it with Criteria, but it should work with the non-type safe one. The type-safe is meant for associations not unrelated entities.