Criteria query involving column @MapKeyJoinColumn ------------------------------------------------- Key: HHH-6548 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6548 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.6.6 Reporter: Anil G Priority: Critical Following is object relationship: Employee mapping contains {code:title=Mapping} @OneToMany(cascade = CascadeType.ALL) @JoinTable(name = "Emp_Field", joinColumns = @JoinColumn(name = "emp_id"), inverseJoinColumns = @JoinColumn(name = "field_value_id")) @MapKeyJoinColumn(name = "field_def_id") public Map<FieldDef, FieldValue> getAttributes() { return attributes; } {code} *CRUD* works amazingly!, but there exists *Critcal* issue with querying such a fields and adding *Order By* {code:title=works only value part of query} DetachedCriteria criteria = DetachedCriteria.forName(Employee.class); criteria = criteria.createAlias("fields","cf"); criteria = criteria.add(Restrictions.eq("cf.value","boonga")); List<Employee> list = getHibernateTemplate().findByCriteria(criteria); {code} It does not permit query invloving Map.key object and Map.value object. as well as does not permit order by Map.key object... {code} fields.key.fieldDef.name="DirectPhone" fields.value.value = "777%" {code} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira