Hibernate reports in-memory pagination warning when using setFirstResult/setMaxResults with join fetch
When using Hibernate’s setFirstResult() and setMaxResults() to paginate a query that also employs join fetch on a @OneToMany association, the ORM may emit the warning HHH000104: firstResult/maxResults specified with collection fetch; applying in memory! . This indicates that Hibernate cannot push the limit/offset clauses to the database and instead loads the