Pasquale Imbemba [
http://community.jboss.org/people/pi4630] created the discussion
"OneToMany bidirectional with composite PKs"
To view the discussion, visit:
http://community.jboss.org/message/631562#631562
--------------------------------------------------------------
Hi,
I kindly ask for help for mapping OneToMany bidirectional with ManyToOne. Consider the
following (for the sake of semplicity):
I have two tables, FOO and BAR. Foo has a PK which is named "ID". BAR has a
composite PK, which is made of ID_FOO (i.e. it's the FK to FOO) and ID.
For both tables, there're the realitve entites, namely Foo and Bar.
Foo has the field id annotated with @Id and contains a field of type Bar (say
'bar') which has the @OneToMany mapped by "foo" - which is the field of
the Bar class. On this field (foo) of the Bar class, I have @ManyToOne and
@JoinColumn(name="ID_FOO") annotated. Foo also has the composite primary key
field fooPk of type FooPK, with @EmbeddedId annotated. The FooPK refers to the two fields,
i.e. the ones mapping ID and ID_FOO.
With this config, I get the error "org.hibernate.MappingException: Repeated column in
mapping for entity:" Foo. when deploying.
If I change the configuration, and use only OneToMany JoinColumn on ID_FOO on the Foo
entity bean and delete the reference back on the Bar entity, it works - but of course, I
can't navigate from Bar to Foo...
So, how do I config the OneToMany bidirectionally, when the "weak" table/class
has a composite primary key?
Thanks,
~pasquale
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/631562#631562]
Start a new discussion in EJB3 at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]