Hibernate version:3.1


Code between sessionFactory.openSession() and session.close():

Criteria criteria = sesion.createCriteria(City.class);
criteria.setFirstResult(1);
criteria.setMaxResults(10);
List results = criteria.list();


Full stack trace of any exception that occurs:
17:55:06,421 WARN JDBCExceptionReporter:71 - SQL Error: 1064, SQLState: 42000
17:55:06,468 ERROR JDBCExceptionReporter:72 - Syntax error or access violation, message from server: "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 'limit 1 10 this_.id as id6_0_, this_.name as name6_0_, this_.idState as idState6' at line 1"


Name and version of the database you are using: mysql

The generated SQL (show_sql=true): select limit ? ? this_.id as id6_0_, this_.name as name6_0_, this_.idState as idState6_0_, this_.zipCode as zipCode6_0_ from CITY this_

I have this problem, the conector is "mysql-connector-java-3.0.14-production-bin.jar" and the version is hibernate 3.1

help please

thanks

luis