Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.2.1ga

I am unable to get a distinct query with multiple entities in HQL to work. It looks like,

select distinct (emp, dept)
from Employee emp, Department dept, Lines l, Costs c
where emp.lid = l.id
and l.cid = c.id
and c.did = dept.id

I would expect to get a list of distinct (emp, dept) combinations in the returned list. However I am getting exceptions like "Expected CLOSE but found a ,"

Firstly, Am I doing the wrong thing in trying to select a distinct tuple of entities. If no, how is this being achieved in Hibernate?

I am attaching the actual SQL queries that got executed,

select
top ? distinct emp5_.id
...
....

With whatever little of SQL that I know, the query should be select "distinct top ? ". A bit of googling pointed me to http://jira.nhibernate.org/browse/NH-829. Could someone tell me if they are related? (It is NHibernate, alright :) )

Apologies for not stating this earlier, I do a

Query q = session.createQuery(..from the string pasted..);
q.setFirstResult(10);
q.setMaxResults(10);

That is throwing the above SQL with the misplaced "distinct" word