Hibernate Distinct Rows

In Hibernate when we do left outer join, sometimes you may get us duplicate rows, as Hibernate entities that we are joining, are themselves joined with some other entities.

For example:

We are joining Class A and Class B but class A already has a join with Class C which may give us duplicate rows. In cases like these Hibernate has DISTINCT_ROOT_ENTITY for rescue, like below.

 @Transactional(readOnly = true)
@SuppressWarnings("unchecked")
public List<Group> getGroups (String id) {
    logger.info("Id is " + id);
    Session session = sessionFactory.getCurrentSession();
    List<Group> groups = session.createCriteria(Group.class)
    .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
    .add(Restrictions.eq("id", id
    .list();
    return groups;
}
Check  out my site seenuonjava.com for more.