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

Hibernate version:3.0.5
I use MySql.
hql="from User limit 5"
and exception: unexpected token: 5
why ?
Is the hibernate version:3.0.5 doesn't sustain limit clause?
which version should i use?

Hi...

You cannot mix sql with hql.
The keyword *limit* is specific of mysql sql dialect while you are using hql which doesn't support this token.

See here http://www.hibernate.org/hib_docs/v3/reference/en/html/queryhql.html#queryhql-expressions
and here http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#querysql-creating

Nico.

don't forget to credit ,-)

thanks for you reply.

i see.
chrisz