hei i have wrote the following query and when i try to execute it . its not converted into hql.

select from CntGroup Limit 3,8;

where as i am using mysql.

= select from CntGroup Limit 3,8
ERROR [http-8080-Processor25] (ErrorCounter.java:33) - line 1:8: unexpected token: from
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: from near line 1, column 8 [se
t.CntGroup Limit 3,8]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:244)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155)

please help me to over come on this

setFirstResult
setMaxResults

See
http://www.hibernate.org/hib_docs/v3/api/ Query interface