query with setFirstResult throws Exception on derby

Description

when do a query with setFirstResult on derby, Exception like below be thrown

[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).

by dig into the code, in

org.hibernate.loader.Loader#prepareQueryStatement

the "scroll" is false, and useScrollableResultSetToSkip is "true", so, the scroll model comes from queryParameters, which is null.

Activity

Brett MeyerMarch 7, 2014 at 10:09 PM

Bulk closing tickets resolved in released versions

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created April 3, 2011 at 4:40 PM
Updated March 7, 2014 at 10:09 PM
Resolved April 6, 2011 at 8:05 PM