Hi,

I have class with a property map as an attribute:

class Test {

Map extraAttributes;

/**
* @hibernate.map table="TestExtraAttributes"
* @hibernate.collection-key column="testId" type="long"
* @hibernate.collection-index column="attributeName" type="string"
* @hibernate.collection-element column="attributeValue" type="string"
*/
public Map getExtraAttributes() {
return extraAttributes;
}

}


Now I want a query to return only Test instances having special extra attributes:


select distinct test
from Test test join test.extraAttributes as extraAttributes
where extraAttributes.index='Color' and extraAttributes.element='Yellow'


The result is an exception

net.sf.hibernate.QueryException: collection of values in from clause:


What is the correct way to query a Map attribute?


I'm using Hibernate 2.0.3

Thanks

Armin

Or, in 2.1 only:

Exactly what I need, thanks

Armin

Hi

I have same requirement, but my class unfortunately has been so designed that there is no getter for the map attribute.
That is, I don't have below method

public Map getExtraAttributes() {
return extraAttributes;
}

Instead of the above I have something like below

private Map extraAttributes;

public static final String _ATTR_HOST_IP_ADDRESS = "_HOST_IP_ADDRESS";

public String getHostIPAddress() {
return (String)getAttribute(_ATTR_HOST_IP_ADDRESS);
}

public Object getAttribute (String attrKey) {
if (null == attrKey) {
return null;
}
return extraAttributes.get(attrKey);
}

So in this case how can I query a row for a particular key value pair in the map. ?

Is it a must I should have getExtraAttributes()

Pl clarify

thanks
Swayam