Mapping question

jm1468 · **Posted:** Sun Dec 11, 2005 8:25 pm

Hey all, i am very new to hibernate so please bear with me. I have a case where lets say I have a person object, very generic. In the person object, there is an id (number), name (map to varchar), age (map to number), blah, blah, then a parent variable that is another Person object. So each Person class has a parent attribute which is a Person object. Lets say in my db, i have 2 tables. 1 called people, 2nd called parents. In the parents table i have only two columns, 1 for parent_id and 2nd for child_id. They both map to the People table using the person_id. How the heck to I map this using hibernate? Please help!!!!

Jason

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

kgignatyev · **Posted:** Mon Dec 12, 2005 4:13 pm

Code:

<hibernate-mapping package="hib.plays">

  <class table="pc_person" name="pc.Person" lazy="false">
    <id name="id">

      <generator class="assigned"/>
    </id>
     <property name="name"/>
     <bag name="parents" table="pc_parents" >
         <key column="child_id"/>
         <many-to-many class="pc.Person" column="parent_id"/>
     </bag>

  </class>

Code:

public void test( Session s ) throws Exception{
    Person p = new Person();
    p.setId( "parent1" );
    p.setName( "pname1" );
    s.save( p );

    Person p2 = new Person();
    p2.setId( "parent2" );
    p2.setName( "pname2" );
    s.save( p2 );

    Person child = new Person();
    child.setId("child1");
    child.setName("child1");
    child.getParents().add( p );
    child.getParents().add( p2 );
    s.save( child );

  }

jm1468 · **Posted:** Mon Dec 12, 2005 7:17 pm

Thanks!