Hibernate criteria for many-to-many entity property

Question

@Entity class A { @ManyToMany private List list; ... } @Entity class B { ... } I'd like to get list from A class using criteria (not sql query). Is it posible to do this? Projection in this case does not work. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Unfortunately, The Criteria only allows selecting the root entity, and not any joined entity. It would thus be easier if your ManyToMany was bidirectional. You could the use the criteria equivalent of select b from B b inner join b.as a where a = :theA If that's not an option, I think the only way is to use a subquery, and thus code the criteria equivalent to select b from B b where b.id in (select b2.id from A a inner join a.list b2 where a.id = :theAId) The code would thus look like this: Criteria c = session.createCriteria(B.class, "b"); DetachedCriteria dc = DetachedCriteria.forClass(A.class, "a"); dc.createAlias("a.list", "b2"); dc.add(Restrictions.eq("a.id", theA.getId())); dc.setProjection(Projections.property("b2.id")); c.add(Subqueries.propertyIn("b.id", dc));