Hi,

I have a POJO Object like below

Class User {

String firstName;
String LastName;
Map properties;
}

The properties attributes is associated in hibernate mapping as below

<map name="properties"
table="User_Properties"
lazy="false"
inverse="false"
cascade="none"
sort="unsorted">
<cache usage="nonstrict-read-write" />

<key>
<column name="PARENT_FK" unique-key="UNIQUEXTS"/>
</key>
<index type="string" column="PROPERTYNAME"/>
<element type="com.db.caaa.domain.GenericProperty">
<column name="PROPERTYVALUE" not-null="false" unique-key="UNIQUEXTS"/>
</element>
</map>

User_properties table has 3 columns parent_fk foreign key to User table and propertyname and propertyvalue.

I want to search for a user with a specific property value. So my HQL is of this type below

Query q = "from User u where u.properties.propertyName ='City' and u.properties.propertyValue ='Singapore'

This query is un-successful. Can anyone help me how to form HQL for the above requirement.

Many thanks in advance

Cheers
Amarnath

There is a slightly different syntax for that, it should be something like this:

Query q = "from User u join u.properties p
where p.propertyName ='City' and p.propertyValue ='Singapore' "