[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-6076) query with setFirstResult throws Exception on derby

query with setFirstResult throws Exception on derby --------------------------------------------------- Key: HHH-6076 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6076 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 4.0.0.Alpha1 Reporter: Strong Liu Assignee: Strong Liu Priority: Critical Fix For: 4.0.0.Alpha2 when do a query with setFirstResult on derby, Exception like below be thrown {quote} [javatest.batch] ERROR: This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_INSENSITIVE). [javatest.batch] javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: This method should only be called on ResultSet objects that are scrollable (type TYPE_SCROLL_INSENSITIVE). {quote} by dig into the code, in {code:title=org.hibernate.loader.Loader#prepareQueryStatement} final boolean useScrollableResultSetToSkip = hasFirstRow && !useOffset && getFactory().getSettings().isScrollableResultSetsEnabled(); final ScrollMode scrollMode = canScroll ? scroll || useScrollableResultSetToSkip ? queryParameters.getScrollMode() : ScrollMode.SCROLL_INSENSITIVE : null; {code} the "scroll" is false, and useScrollableResultSetToSkip is "true", so, the scroll model comes from queryParameters, which is null.