[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6548) Criteria query involving column @MapKeyJoinColumn

[Anil G (JIRA)]

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