Hibernate Pagination Limits with Join Fetching
Hibernate Pagination Limits with Join Fetching Hibernate exposes pagination through setFirstResult() and setMaxResults() on the Query interface. The generated SQL is dialect-dependent, using LIMIT/OFFSET or window functions according to the configured Database Dialect. A documented constraint appears when those methods are combined with JOIN FETCH on collect