Hibernate Community • View topic - many to one with composite key

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

many to one with composite key

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

tonykok

Post subject: many to one with composite key

Posted: Thu Jun 03, 2010 7:57 am

Newbie

Joined: Thu Jun 26, 2008 3:35 am
Posts: 3

I have a table named TableA wich refers to tables TableB1, TableB2, TableB3 by a composite foreign key.
These two columns are FK_B_ID and FK_Type_ID.
What I want to accomplish is to retreive EntityB1 when FK_Type_ID is 1, EntityB2 when FK_Type_ID is 2 and so on.
How would my mappings look like in order to achieve this?

thank you

Top

Partyk1d24

Post subject: Re: many to one with composite key

Posted: Thu Jun 03, 2010 3:16 pm

Newbie

Joined: Mon Feb 09, 2009 11:52 am
Posts: 11

This might help...

https://forum.hibernate.org/viewtopic.php?f=25&t=1004984&p=2431328#p2431328

Top

tonykok

Post subject: Re: many to one with composite key

Posted: Fri Jun 04, 2010 5:27 am

Newbie

Joined: Thu Jun 26, 2008 3:35 am
Posts: 3

Thank you for your response. In fact I was expecting for something like this

<many-to-one name="product" class="Product" column="PRODUCT_ID">
<discriminator column="productType" discriminator-value="1"/>
/>

<many-to-one name="service" class="Service" column="PRODUCT_ID">
<discriminator column="productType" discriminator-value="2"/>
/>

is this kind of mapping possible?

Top

Page 1 of 1

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