Query.setMaxResults does not work with Mysql Connector version 3.1.6, but works with 3.0.14 ------------------------------------------------------------------------------------------- Key: HHH-1341 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1341 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.1 Environment: Hibernate 3.1, Mysql Server 4.1.3, Mysql Connector 3.1.6 bzw. 3.0.14, JRE 1.5.0_06, winxp Reporter: Stefan Reger Assignee: Strong Liu Priority: Minor With Mysql Connector version 3.1.6: Setting query.setMaxResults(1000) results in console output: "Hibernate: select [...] limit ? 13:38:47,296 WARN JDBCExceptionReporter:71 - SQL Error: 1064, SQLState: 42000 13:38:47,296 ERROR JDBCExceptionReporter:72 - 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 '?' at line 1" The query without setting the result limit succeeds. Mysql Connector 3.0.14 works perfectly. Please verify.