Hibernate Community • View topic - conditional Parent/Child mapping

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

conditional Parent/Child mapping

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

dkode

Post subject: conditional Parent/Child mapping

Posted: Wed Jul 18, 2007 10:25 pm

Beginner

Joined: Thu Aug 17, 2006 3:20 pm
Posts: 21

Ok,

I know there must be an easy solution to this, but it is beyond me at the moment. Here are my entities, pretty basic:

Item (1) --> (0..*) Photo

Profile (1) --> (0..*) Photo

So both Item and Profile have a one-to-many association to Photo, originally I had a table called ItemPhoto and a table called ProfilePhoto, but when I attempted to map this, I got a duplicate mapping exception and realized I wasn't able to do this as both mapping files would be mapping the Photo entity, only with different table names.

How would I map this in the DB? Make two subclasses for Photo and do a table-per-subclass? That seemed a little cumbersome just to get the mapping to the db.

I know there must be a simple solution, i've just stared at it for too long =P

Top

radic

Post subject:

Posted: Thu Jul 19, 2007 3:01 am

Beginner

Joined: Tue May 08, 2007 8:26 am
Posts: 21

Code:

Item:
...
   <set name="photos" inverse="true">
       <key column="item_id" />
       <one-to-many class="package.ItemPhoto" />
   </set>
...

Profile:
...
   <set name="photos" inverse="true">
       <key column="profile_id" />
       <one-to-many class="package.ProfilePhoto" />
   </set>
...

if you want bidirectional, put a one-to-one in photo classes as well: