[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3646) implement Criteria API querying of collection-of-component

implement Criteria API querying of collection-of-component ---------------------------------------------------------- Key: HHH-3646 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3646 Project: Hibernate Core Issue Type: Patch Components: query-criteria Affects Versions: 3.2.6 Environment: hibernate 3.2.6, tested on linux 64-bit openjdk 1.6 (jdk1.5 for compiling). mapping created under annotations 3.3.1ga Reporter: David Mansfield Assignee: Steve Ebersole Fix For: 4.0.0.Alpha2 Attachments: 0001-only-prepend-the-a-comma-when-we-definitely-have-a-s.patch, 0002-throw-a-better-exception-if-an-attempt-is-mado-to-pu.patch, 0003-implement-criteria-query-of-collection-of-component-.patch, 0004-implement-a-test-case-for-query-collection-of-value.patch, 0005-implement-a-test-case-for-query-collection-of-compon.patch, hib-core-query-collection-of-elements-3_2_6-ver2.patch, hib-core-query-collection-of-elements-3_2_6.patch, hib-core-query-collection-of-elements-3_3_1-ver5.patch, hib-core-query-collection-of-elements-3_3_1-ver6.patch Original Estimate: 8h Remaining Estimate: 8h the attached patch implements a first cut, extremely rough, yet working extension of the CriteriaQueryTranslator class to allow for querying of properties of components inside a collection, or querying properties of associated elements of components inside a collection. eg for * code is lightly tested, this example is for illustrative purposes only * i use annotations, so my example is expressed in those terms, and i've only tested with mappings generated via annotations, however, the modifications only apply to the core. @Entity class Order { @Id String id; @CollectionOfElements Set<OrderLineItem> lineItems; } @Embeddable class OrderLineItem { @ManyToOne Product product; Integer quantity; } @Entity class Product { String name; } Then we can now do: Criteria c = session.createCriteria(Order.class) .createCriteria("lineItems") .add(Restrictions.gt("quantity", new Integer(1)) .list(); or Criteria c = session.createCriteria(Order.class) .createCriteria("lineItems") .createCriteria("product") .add(Restrictions.like("name", "cake%") .list();