i saw a lot of example on the web regarding to do a typical m-m relationship. but i've a problem.

assume i have 3 tables.

user -> uid, name

course -> cid, name

subscription -> uid, cid, status
______

if i'd use the normal

<set name="courses" table="subscription" inverse="true">
<key column="uid" />
<many-to-many column="cid"
class="xxx.Course" />
</set>

and

<set name="users" table="subscription">
<key column="cid" />
<many-to-many column="uid"
class="xxx.User" />
</set>

i can't retrieve the status field in the subscription table.

is there any solution?

check composite element in the reference guide, hibernate in action, i think there are many examples in the forum too.

yes, i guess i did solve this one. but i don't know i solve in a good way or not.

__


<class name="net.insyn.hub.domain.ex.Subscription" table="usercourse" >
<composite-id>
<key-property name="status" column="status" />
<key-many-to-one name="users" class="net.insynchro.phub.domain.ex.User" column="userid"/>
<key-many-to-one name="courses" class="net.insynchro.phub.domain.ex.Course" column="courseid"/>
</composite-id>
</class>

__


this is the hashcode func in the subscription class

__

public int hashCode() {
int result;
result = Integer.parseInt(user.getUserId());
result = 29 * result + Integer.parseInt(package.getId());
return result;
}

__


stdout -> from object in class net.insynchro.phub.domain.ex.Subscription

__

is that the only way to access the status field? is this way of doing elegant? is there any other better way to do it?