Hi.

Is it possible to query for keys and values of a map?

I have a class with an attribute "private Map properties". The mapping is like follows:

<class name="Configuration">
...
<map name="properties">
<key column="configuration_id" not-null="true" />
<map-key column="key" type="string" length="50" />
<element column="value" type="string" length="255" not-null="true" />
</map>
</class>

Now I would like to select all "Configuration" objects which have an entry "testkey" with the value "testvalue" in the map.

I tried "FROM configuration AS c WHERE c.properties.key='testkey' and c.properties.element='testvalue'", but Hibernate complains about the dot between "properties" and "keys".

I also tried "FROM configuration AS c WHERE c.properties.key IS NOT NULL" just to see if there is any possibility to specify the entries of the map, but I always get a "hql.ast.QuerySyntaxError" for the 2nd dot.

I am using Hibernate 3.0.5.

Try:

Does it work for you?