Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

one-to-many example

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jiseller

Post subject: one-to-many example

Posted: Fri Jan 14, 2005 10:55 am

Beginner

Joined: Wed Nov 24, 2004 10:54 am
Posts: 48

Hibernate version:2.1.7

I have been reading Hibernate in Action also have resarched this forum for some examples of one-to-many. My problem is that on my many side I have a composite key. Here is an example.

This is the many side

Code:

...
<composite-id name="heligpKey"> 
        <key-property name="subscriberNo" column="SUBNO"/> 
        <key-property name="personNo" column="PERNO"/> 
        <key-property name="eligStartDate" column="ESTDT" type="java.lang.Integer"/>        
        <key-property name="eligEndDate" column="EENDT" type="java.lang.Integer"/>     
</composite-id> 

On my one side I also have composite key..

Code:

<composite-id name="hmembpKey">
    <key-property name="subscriberNo" column="SUBNO"/>
    <key-property name="personNo" column="PERNO"/>
</composite-id>

What is the best approach to mapping this type of relationship? is a one-to-many the best way, parent-child, set....?? Is there an example?

Thanks

Top

jiseller

Post subject:

Posted: Fri Jan 14, 2005 1:41 pm

Beginner

Joined: Wed Nov 24, 2004 10:54 am
Posts: 48

OK, after much research, reading, more research and even more reading I got it to work. Here is my solution. Simple, once I figured it out.

My mapping in hmembpBean.hbm.xml.....

Code:

.....
<set name="eligSet" lazy="true" inverse="true">
      <key>
          <column name="SUBNO"/>
          <column name="PERNO"/>
     </key>
      <one-to-many class="com.sys.dao.HeligpBean"/>
</set>
.....

My HQL...

Code:

FROM HmembpBean hmembpBean  left join fetch hmembpBean.eligSet eligSet WHERE ....

And "BEHOLD" it works!

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum