How to write select with LIMIT keyword using HQL?

DarkCloud · **Joined:** Mon May 14, 2007 2:50 am **Posts:** 22

Hibernate version:
1.2

Is it possible to write HQL to limit returned results?
For example, :

Code:

"from Role r LIMIT 10";

Or do i have to use something like:

Code:

Post post = (Post)session.CreateCriteria(typeof(Post))
     .Add(Expresion.Like("Title", title))
     .AddOrder(Order.Asc("PublishedAt"))
     .SetFirstResult(0)
     .SetMaxResult(1)
     .UniqueResult();

karlchu · **Posted:** Wed Sep 19, 2007 10:06 am

Code:

IQuery q = session.CreateQuery("from Role")
    .SetMaxResult(10);

DarkCloud · **Joined:** Mon May 14, 2007 2:50 am **Posts:** 22

karlchu wrote:

Code:

IQuery q = session.CreateQuery("from Role")
    .SetMaxResult(10);

Ok, I got it:)
Limit is not supported in HQL

thanks!

Lenbok · **Joined:** Wed Dec 12, 2007 5:31 pm **Posts:** 1

It would be nice to add this as a feature, to enable named queries to include the limit.