hi,
if I have two tables, Structures and Employes

<class name="Employes" table="employes">
<cache usage="read-only"/>
<composite-id name="id" class="EmployesKey">
<key-many-to-one name="structures" class="Structures">
<column name="idstruct" />
<column name="datestruct" />
</key-many-to-one>
<key-property name="codemployee" column="codemployee" type="java.lang.String"/>
<key-property name="otherkey" column="otherkey" type="java.util.Date"/>
</composite-id>
...
</class>

<class name="Structures" table="structurs">
<cache usage="read-only"/>
<composite-id name="id" class="StructuresKey">
<key-property name="idstruct" column="idstruct" type="java.lang.String"/>
<key-property name="datestruct" column="datestruct" type="java.util.Date"/>
</composite-id>

...
<set name="employesSet" inverse="true">
<key>
<column name="idstruct"/>
<column name="datestruct"/>
</key>
<one-to-many class="Employes"/>
</set>

</class>

is it possible to write a query like this?

select distinct s from Structures s, Employes e
where s.id = e.id.idstruct

I tried but I got a syntax error.
I also tried with

...where s.id.idstruct = e.id.idstruct
and s.id.datestruct = e.id.datestruct

but in this case the raised exception is "could not resolve property: idstruct of: Structures [query]"

Hi,
Here is example, You can try with createCriteria. you can expand on this example and hope it works.




My Forte 4GL and Spring Blog
srigold