Hi,

could come nody provid me an example of using the criteria api for a one to many unidirectional relationship with a join table.
I have the USER table that have a one to many unidirectional realtionship with ROLE table (where a user could have many roles)...and i have UserRole join table.

I want to know how i could use the criteria api to retrieve users for a specific role.

could come body give me an example.

Can u paste the mapping ?

You can use the below one .


session.createCriteria(user.class).createCriteria("userrole")
.add(Expression.eq("role", "Search")).list();

here userrole is a collection property in user class containing the data from join table.

Regards
Gokul

here is the mapping:

For the member model:
<hibernate-mapping>

<class name="com.motorola.osrb.justifications.client.model.OSRBMember" table="OSRBMEMBERS">
<cache usage="read-write"/>
<id name="ID" column="ID" type="long"><generator class="increment"/></id>
<property name="coreid" column="coreid"/>
<property name="state" column="state"/>

<set name="roles" table="OSRBMEMBERROLE">
<cache usage="read-write"/>
<key column="ID"/>
<many-to-many column="roleID"
unique="true"
class="OSRBRole"/>
</set>
</class>

</hibernate-mapping>
--------------------------------------------------------
And for the Role model:
<hibernate-mapping>

<class name="com.motorola.osrb.justifications.client.model.OSRBRole" table="OSRBROLE">
<cache usage="read-write"/>
<id name="ID" column="roleID" type="long"><generator class="increment"/></id>
<property name="role" column="role"/>
</class>
</hibernate-mapping>


do you think that example code that you post is going to work for this mapping. I fallow up the hibernate tutorial advice which is telling to use a join table for one to many unidirectional association in my mapping xml code.

I need to be able to retrieve all the members for a specific role...and also obtain the role of the specific member...by using the criteria api.

Thanks for your help.

the the below one

session.createCriteria(OSRBMember.class).createCriteria("roles")
.add(Expression.eq("ID", "Search")).list();

i hope this would work perfectly !!!

session.createCriteria(OSRBMember.class).createCriteria("roles")
.add(Expression.eq("ID", "Search")).list();

i presume that this must be the code to retreive roles for a specific OSRBMember where ID is the id of the OSRBMember.

How should i do if i want to retrieve all the OSRBMembers for a specific role (Example role=OSSEXpert)

session.createCriteria(OSRBMember.class).createCriteria("roles")
.add(Expression.eq("role", "OSSEXpert")).list();

this will retrieve all the users having role OSSEXpert


PS : please don't forget to give credits below if you found this answer useful :)

session.createCriteria(OSRBMember.class).createCriteria("roles")
.add(Expression.eq("role", "OSSEXpert")).list();

this will retrieve all the users having role OSSEXpert


PS : please don't forget to give credits below if you found this answer useful :)