you can not generate "update top 10 Table_name" sql query with query.executeUpdate --------------------------------------------------------------------------------------- Key: HHH-4017 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4017 Project: Hibernate Core Issue Type: Bug Components: query-hql Affects Versions: 3.3.2 Environment: hibernate-distribution-3.3.2.GA , SQL Server 2005 Reporter: Parisa Kachoui The query.executeUpdate ignores the query.setMaxResult(10) . for example if you have this query : Query query = session.createQuery("update table_name t set t.fieldname= ?) query.setString(0, fieldValue); query.setMaxResults(10); int i = query.executeUpdate(); it generates "update table_name set fieldName := fieldValue" sql query instead of this query "update top 10 table_name set fieldName := fieldValue" so now way you can't have top 10 records in update query -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira