I have a HQL query in the from clause and it keeps on complaining. Please see below for error and actual query:


net.sf.hibernate.QueryException: in expected: select [select distinct incident from ( select distinct rownum r, incident from com.bagnet.nettracer.tracing.db.Incident incident where 1=1 and incident.itemtype.itemType_ID = :itemType_ID order by incident.incident_ID ) where r between 0 and 15]




Any help will be highly appreciated.


Thanks,

Ankur

HQL subqueries may occur only in the select or where clauses.

Hibernate reference
14.12. Subqueries