Ruben Laguna's blog

Sep 11, 2009 - 1 minute read - apache derby fetch java jpa limit offset pagination persistence setfirstresult setmaxresults

Derby 10.5 "OFFSET/FETCH" and JPA

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”