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
One Comment
tnx for a post.
i’ve found that there is a pacth for Hibernate’s DerbyDialect here http://opensource.atlassian.com/projects/hibernate/browse/HHH-3972. And FETCH/OFFSET logis is implemented in DerbyDialect from hibernate-core-3.5-beta-2. I’ve now checked beta-3 – there it is! But have not not tested it in practice yet.