It seems that no current JPA implementation is able to paginate the result using Apache Derby 10.5 OFFSET/FETCH mechanism. So javax.persistence.Query setFirstResult and setMaxResults don’t really translate into proper pagination with “OFFSET/FETCH”
- TopLink/EclipseLink org.eclipse.persistence.platform.database.DerbyPlatform
- Hibernate org.hibernate.dialect.DerbyDialect
- OpenJPA. org.apache.openjpa.jdbc.sql.DerbyDictionary