how to mapping like this?

xmvigour · **Joined:** Wed Aug 27, 2003 2:49 am **Posts:** 8

example:
menu{id,name,fid}
so a menu A have any children menu .and the fid of children menu equals the id of A.

how to mapping ?

xmvigour · **Joined:** Wed Aug 27, 2003 2:49 am **Posts:** 8

users

Code:

<class name="Users" table="Users">
      <id name="userid" type="string">
         <column name="userid" />
         <generator class="uuid.hex"/>
      </id>
      <property name="password" column="password" type="string"/>
      <property name="enabled" column="enabled" type="boolean"/>
      <property name="userNick" column="userNick" type="string"/>
      <set name="menus" inverse="true" lazy="true" cascade="all">
         <key column="userid"/>
         <one-to-many class="Menu"/>
      </set>
      <property name="userName" column="userName" type="string"/>
   </class>

menu:

Code:

 <class name="Menu" table="Menu">
                <id name="menuid" type="string">
                        <column name="menuid" />
                        <generator class="uuid.hex"/>
                </id>
                <property name="menuName" column="menuName" type="string"/>
                <many-to-one name="user" class="Users" column="userid" not-null="true"/>
                <property name="link" column="link" type="string"/>
                <property name="description" column="description" type="string"/>
                <set name="childmenus" lazy="true" cascade="all" inverse="true">
                        <key column="fid"/>
                        <one-to-many class="Menu"/>
                </set>
        </class>

it work success between users and menu.
but how to do with the menu and its childmenus;

menu.java

Code:

public class Menu {
   private Set childmenus;
   private String description;
   private String link;
   private String menuid;// the Hibernate identifier
   private String menuName;
   private Users user;
..........................
//other is common setter and getter
}

when i add a children menu to a menu.

Code:

   child=new Menu();
                     child.setMenuName("childtest");
                     child.setDescription(" a child menu for file0");
                     child.setUser(users);
                     Set childmenus=new HashSet();
                     childmenus.add(child);
                     menu.setChildmenus(childmenus);

but the new record in the database has not a fid .

pls tell me why?

emmanuel · **Posted:** Wed Nov 26, 2003 2:45 pm

Since you inverse=true the collection, the other side is responsibel of updating the link.
http://www.hibernate.org/Documentation/InsideExplanationOfInverseTrue

1. Add a many-to-one association to "parentMenu", and do childMenu.setParentMenu(parentMenu);

2. set inverse="false" (default). But this may be inefficient see the parent child relationship chapter on the reference guide.

DavidNDuffy · **Posted:** Wed Nov 26, 2003 3:26 pm

Check out the composite pattern on the wiki at:
http://www.hibernate.org/86.html

Quote:

but the new record in the database has not a fid .

You haven't mapped it that I can see.
You need:

Code:

<many-to-one name="parent" column="fid" cascade="save-update" class="Menu"/>

...and of course add the parent Menu reference to your Menu class.
This will make it a bidirectional association as per epbernard's reply.

xmvigour · **Joined:** Wed Aug 27, 2003 2:49 am **Posts:** 8

i have correct my code.

and it is ok!

but now i have another problem .
i want that the User Object get the menus not include the childmenus.
example:
user->menu(top level)->childmenus

how can i implement it?

xmvigour · **Joined:** Wed Aug 27, 2003 2:49 am **Posts:** 8

i change my user.hbm.xml.

Code:

<set name="menus" inverse="true" lazy="true" cascade="all" [b]where="fid is null"[/b]>
         <key column="userid"/>
         <one-to-many class="Menu"/>
      </set>

and it is ok now.