Configuring Hibernate join‑fetch pagination with distinct results in Red Hat JBoss EAP
Goal: Retrieve paginated lists of parent entities with their child associations using Hibernate’s setFirstResult and setMaxResults together with left join fetch, while ensuring each parent appears only once per page. Constraints: The application runs on Red Hat JBoss EAP 7.x (Hibernate ORM 5.0‑5.6), where the default limit/offset behavior can produce duplica