I would like to load the structure at once !
core_usergroup(id:int, name:varchar)
core_usermembership(usergroup_child:int, usergroup_parent:int)
core_userpassword(usergroup_id:int,data:datetime,value:varchar)
how can I do ?? ok fetch join I was answered... but how ?
session.find("From CoreUsergroup as user left join fetch user.children left join fetch user.parents left join fetch user.coreUserPasswords") ?
once in cache, I would like to have the list of all usergroups to handle it by myself... how to ?
iterate("From CoreUsergroup") ? it still does a sql request to retreive IDs... I don't want that ! And if I delete an object, the next time I call iterate, it still gives me the deleted ID and it crashes in IterateImpl)
I don't understand how the cache work ! Could someone explain ? Or is there any article to read on this ?
This is what I have :
I have a usergroup table that can contains other usergroups and be contained in other usergroups.
A usergroup also has a list of password (don't ask why)
Here is my xml :
Quote:
<hibernate-mapping>
<class name="test.CoreUsersgroup"
table="core_usersgroups" dynamic-update="false" dynamic-insert="false">
<cache usage="read-write" />
<id name="id" column="id" type="java.lang.Integer" unsaved-value="-1" >
<generator class="hilo">
<param name="table">hibernate_unique_key</param>
<param name="column">core_usersgroups</param>
<param name="max_lo">0</param>
</generator>
</id>
<property name="name" type="java.lang.String" update="true" insert="true" column="name" length="50" not-null="true"/>
<set name="children" lazy="false" inverse="true" cascade="delete" sort="unsorted">
<cache usage="read-write" />
<key column="usergroup_child" />
<one-to-many class="test.CoreUserMembership" />
</set>
<set name="parents" lazy="false" inverse="true" cascade="delete" sort="unsorted">
<cache usage="read-write" />
<key column="usergroup_parent" />
<one-to-many class="test.CoreUserMembership" />
</set>
<set name="coreUserPasswords" lazy="false" inverse="false" cascade="delete" sort="unsorted">
<cache usage="read-write" />
<key column="usergroup_id" />
<one-to-many class="test.CoreUserPassword" />
</set>
</class>
</hibernate-mapping>
Thank you very much