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

Hibernate version:3.3.1GA

My SQl: 5.0

MySql-connector -5.0.8:

Pagination is not working. It gives the following error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '() as rownumber_, this_.USER_ID as USER1_0_0_, this_.CLIENT_ID as CLIENT16_0_0_,' at line 1
could not execute query

Read this: http://hibernate.org/42.html