How to implement multiple inner join in Hibernate

Question

product_template, product_account, product_style and product_account are tables. mysql command:

select distinct product_template.id as ptid from product_account inner join product on product_account.productId=product.id inner join product_style on product.productStyleId=product_style.id inner join product_template on product_style.productTemplateId=product_template.id where product_account.sellerId=1 and product_account.productAccountType=1;

Mysql command is working fine but I don't know how to implement in criteria.
My code:

Criteria c = createCriteria(ProductAccount.class);
ProjectionList projectionList = Projections.projectionList();
c.add(Restrictions.eq("seller", query.getSeller()));
c.add(Restrictions.eq("productAccountType", query.getProductAccountType()));
c.createCriteria("product").createCriteria("productStyle").createCriteria("productTemplate");
c.setProjection(Projections.distinct(Projections.property("id")));
List<Object> objects = c.list();

Iam getting only id's of product_account but I need id's of product_template. Any would be appreciated. Thanks in advance.

See this http://stackoverflow.com/questions/8726396/hibernate-criteria-join-with-3-tables — Evgeni Dimitrov, Jun 06 '13 at 08:45
Your `createCriteria` method implementation is likely incorrect. Please include it in the question. — sharakan, Jun 17 '13 at 16:12

score 3 · Accepted Answer · answered Jun 26 '13 at 13:06

Trt this

Criteria c = createCriteria();
c.add(Restrictions.eq("seller", query.getSeller()));
c.add(Restrictions.eq("productAccountType", query.getProductAccountType()));
c.createCriteria("product").createCriteria("productStyle").createCriteria("productTemplate", "pt");
c.setProjection(Projections.distinct(Projections.property("pt.id")));
List<Object> objects = c.list();

score 1 · Answer 2 · answered Jun 17 '13 at 16:50

Criteria c = createCriteria(ProductAccount.class);
c.add(Restrictions.eq("seller", query.getSeller()));
c.add(Restrictions.eq("productAccountType", query.getProductAccountType()));
c.createCriteria("product")
    .createCriteria("productStyle")
    .createCriteria("productTemplate", "pt"); //This needs an alias
c.setProjection(Projections.projectionList()
    .add( Projections.distinct( Projections.property("id") ) )
    .add( Projections.property("pt.id") )); //Add it to the projection list
List<Object> objects = c.list();

btw, is your code already working?, because the first criteria class was missing

How to implement multiple inner join in Hibernate

2 Answers2