I have the following query in HQL that I'm struggling to convert into a Hibernate Criteria query:

Query (*Note: Number of properties queried can vary)
------------------------------------------------------
select e from Entity e
where
true
and exists (from e.props as p where p.name = 'a' and p.value='1')
and exists (from e.props as p where p.name = 'b' and p.value='2')

Data-Model
------------
<hibernate-mapping>
<class name="com.x.Entity" table="ENTITY">
<id name="id" column="ID">
<generator class="native" />
</id>

<property name="name" column="NAME" type="string"/>
<set name="props">
<key column="entity_id"/>
<one-to-many class="com.x.Property"/>
</set>
</class>

<class name="com.x.Property" table="PROPERTY">
<id name="id" column="id">
<generator class="native" />
</id>
<property name="name" column="name" type="string"/>
<property name="value" column="value" type="string"/>
</class>
</hibernate-mapping>




Example Data
------------------------------------------------------
Entity 1:
name: ent1-a1-b2,
Properties (name,value):
("a", "1")
("b", "2")

Entity 2:
name: ent1-a1-c3,
Properties (name,value):
("a", "1")
("c", "3")

Entity 3:
name: ent1-b2-c3,
Properties (name,value):
("b", "2")
("c", "3")


Result of query in this case should return the Entity "ent1-a1-b2".


Thanks in advance

Hi,
I'm not sure how to create that particular query.

It should be something like:



But isn't your query equivalent to:



the criteria equivalent would be:


Note that I haven't tested these queries so I'm not sure they will work.

Hope this help,
Davide