NHibernate 1.2.0.4000

Hello,

I've got a problem with an HQL Query :

Let's consider the following mapping :

A [Person] can have many [Phone] and each [Phone] has a [PhoneType]. For example,"personal", "professiona"l and "mobile".

What I'd like to get is a list of all the persons with only their optional mobile phones.



The problem is that if I do this :
FROM Person
LEFT JOIN Person.Phones Phone
LEFT JOIN Phone.PhoneType PhoneType
WHERE PhoneType.Name = 'Mobile'

Then, I would not list the persons that don't have mobile phones.



What I missed is How should I do to write a query like :
FROM Person
LEFT JOIN Person.Phones Phone
LEFT JOIN Phone.PhoneType ON PhoneType.Name = 'Mobile'


Thank you very much for any answer.

Laurent MONDEIL

I do not have a solution for you but I have a similar problem. I'm looking for a way to express a statement like this in HQL. Note: (+) is the Oracle Syntax for left outer join

SELECT A.id, c.position
FROM people A, department B, position C
WHERE A.id = B.id (+)
AND A.id = C.id
AND B.depid IS NULL

What it does is selecting id and position of those people who not yet have a depid.

All HQL examples I have seen did not make an outer join across different relations?! Thanks a lot!

This is a known limitation in NHibernate. A JIRA issue has been logged quite a while ago. The solution is to port the enhancements from Hibernate 3.x to NHibernate.

Please vote for the issue at http://jira.nhibernate.org/browse/NH-514

Thank you Nels,

I will vote for that issue. I was already evaluating other O/R-Mappers. For now my solutions is simply to create a View for that query or actually for a more complicated one but the reason why I didn't get it to work was the left outer join as described above. It's a very important query for our project and therefore I can justify a view but in general one does not want to clutter his schema with views just because HQL does not support a specifice query. It makes the mapping less transparent too.