Query an associated map with Criteria API

barabaka · **Joined:** Thu Nov 30, 2006 10:06 am **Posts:** 9

Is it ever possible to query for a map key with Criteria API? HQL manages it quite well, e.g.

Code:

from User where contacts['email'] = 'me@localhost'

but Criteria API warns you that it cannot find a property if you try to add smth like: Restrictions.eq("contacts['email']","me@localhost").

The mapping is:

Code:

<class name="User">
...
<map name="contacts" ...>
...
</map>
</class>

sethrohit1977 · **Joined:** Mon Jan 22, 2007 10:32 am **Posts:** 101

As far as I know, such query is not possible through criteria api.