Return to Snippet

Revision: 51447
at September 24, 2011 19:23 by corporem


Initial Code
public List<Item> findBySectionId(Integer sectionId) {
        return getCurrentSession().createCriteria(Item.class, "i")
                .createAlias("i.sections", "s", Criteria.LEFT_JOIN)
                .add(Restrictions.eq("s.id", sectionId))
                .list();
//
//        return  getCurrentSession().createQuery("select distinct i from Item i left join i.sections s where s.id=:id")
//                .setParameter("id",sectionId).list();
    }

Initial URL


Initial Description


Initial Title
Hibernate Criteria Left Join

Initial Tags


Initial Language
ActionScript 3