HQL help needed

[Venkata Kumar]

Hi All,

I have two objects Person, Manager and the objects are mapped to database tables Person and Manager. I want to get all the persons having no manager at all or having manager whose name is "xyz".

public class Person {
       Long id;
       String name;
       Manager manager;    
}

public class Manager {
      Long id;
      String name;
}

SQL query to get the desired result is

select p.name
		from person p
		where person.manager_fk is null
union
select p.name
	from person p,
	     manager m
	where p.manager_fk = m.id
	and m.name= = 'xyz'

I want to get the same result using HQL query and tried the following HQL query. But it is not giving expected results.

select p.name 
from Person p
where p.manager is null or p.manager.name ='xyz'  

Any help on HQL query is appreciated.

Thanks,
Venkat

[Arun Kumarr]

Use joins.
Hibernate support for unions is selective.
If you're still uncomfortable and have a complex query, user result set transformer AliasToEntity Mapping and map your query results into your pojo.
But, in this case, I would suggest you to use a simple join.