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