I'm using HQL, which is Hibernate's SQL. I'm hoping it works
I have the following HQL
select distinct r from Release as r, ReleaseComponent as c
where r.deploymentDate between :fromDate and :toDate and r.name like :rName
and r.status like :rStatus and r.components.id = c.id and c.owner.userId like :cOwnerId
and c.externalId like :cExternalId limit 4
and I get an error of "unexpected token: limit "
Did i use this wrong? Is there a work around this LIMIT?