Hibernate Community • View topic - Getting extra info from many-to-many relationship

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Getting extra info from many-to-many relationship

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

huijzer

Post subject: Getting extra info from many-to-many relationship

Posted: Tue May 25, 2004 8:59 am

Newbie

Joined: Tue May 25, 2004 8:50 am
Posts: 8

I have three columns in the database:

DISC with columns ID and TITLE
SONG with columns ID and TITLE
DISC_SONG with columns DISC_ID, SONG_ID and SEQUENCE

In my mapping file I have the following lines:

Code:

<set name="songs" table="disc_song"  order-by="sequence asc">
  <key column="disc_id" />
  <many-to-many column="song_id" class="com.huijzer.musicweb.Song" />
</set>

When I retrieve the relevant song objects with the following code:

Code:

Set songs = myDisc.getSongs();

I would like the returned Song objects to include the SEQUENCE column so I can use

Code:

mySong.getSequence()

to return the sequence column for that particular Disc.

Is this possible?

Thanks in advance for any help!
Arjan Huijzer

Top

subich

Post subject:

Posted: Tue May 25, 2004 9:11 am

Senior

Joined: Fri Nov 21, 2003 5:55 am
Posts: 155

Look the documentation examples with the product customer and order case.
You can use a component element to manage this case.
or 2 one to many relationships.

Top

huijzer

Post subject:

Posted: Tue May 25, 2004 9:25 am

Newbie

Joined: Tue May 25, 2004 8:50 am
Posts: 8

Thanks! I'll look at the example :-)

Top

Page 1 of 1

[ 3 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