ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Implement efficient server-side pagination in Hibernate 5.2+ and 6.x using the JPA Criteria API (CriteriaBuilder/CriteriaQuery). Avoid OutOfMemoryErrors, understand the collection fetch trap (HHH000104), and verify database-level LIMIT/OFFSET generation.
How Hibernate's setFirstResult and setMaxResults implement database-level pagination, with a worked JPQL example, count-query guidance, the large-offset performance trap, and when to switch to keyset pagination.
A diagnostic workflow for Hibernate N+1 selects on paginated endpoints: confirm the query count, identify the triggering association, and apply JOIN FETCH, two-query pagination, or entity graphs without falling into the in-memory pagination trap.
A diagnostic guide for Spring Data JPA LazyInitializationException: recognize the condition, trace the transaction boundary, use a cause table, ordered checks, targeted fixes (fetch joins, DTOs, open-in-view), and escalation criteria for pagination and async paths.
Learn how to diagnose and fix the HHH000104 warning in Hibernate, which causes dangerous in-memory pagination when using JOIN FETCH with collections.
Learn how to define and execute paginated named queries in Hibernate. This article walks through the exact configuration, execution, and common pitfalls, so you can fetch large datasets efficiently and safely.
Learn how to implement and optimize pagination and sorting in JHipster to prevent OutOfMemoryErrors and improve database performance using Spring Data JPA.
Move pagination and filtering to the database with Hibernate Criteria API. Learn the fetch-join trap, deep-paging fixes, and a verification checklist that prevents production surprises.
Stop using setFirstResult() for deep pagination in Hibernate. Learn why offset-based pagination slows down and how to implement the Keyset (Seek) method for constant-time performance.
hibernate
norg
npss
jhipster
java