Hibernate Community • View topic - Several foreign keys to the same table.

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Several foreign keys to the same table.

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

hopsoid

Post subject: Several foreign keys to the same table.

Posted: Tue Oct 23, 2007 1:03 pm

Newbie

Joined: Tue Oct 23, 2007 12:41 pm
Posts: 1

Hi,
I'm new to Nhibernate and I have a question about mapping files.
I have a simple database in Mysql 5 with these innoDB tables.
City(id, name)
Trip(id, orig_city, dest_city)
Both orig_city and dest_city are foreign keys to the City table

If I want to use collections for the bags, what should I do?
Do I have to do this:
city.hbm.xml

Code:

<bag name="TripList1" inverse="true" lazy="true" >
 <key column="orig_city" />
 <one-to-many class="Trip" />
</bag>
<bag name="TripList2" inverse="true" lazy="true" >
 <key column="dest_city" />
 <one-to-many class="Trip" />
</bag>

trip.hbm.xml

Code:

<many-to-one name="OrigCity" column="orig_city" class="City" />
<many-to-one name="DestCity" column="dest_city" class="City" />

and then do everything twice in the city.cs (members, property, add )?

Thanks,

Top

merge_s.rottem

Post subject:

Posted: Tue Oct 23, 2007 4:17 pm

Expert

Joined: Tue Aug 23, 2005 5:52 am
Posts: 335

The city class only needs to be defined once with two collections; TripList1 and TripList2.

Symon.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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