Hi, The error message indicates org.hibernate. This forum is for the apache openjpa project.
Kevin On 6/2/09, gwo58ns <[email protected]> wrote: > > I have 2 tables that I'm trying to do a left outer join on. > > > Code: > "FROM Family AS f INNER JOIN f.personVersion AS pv > LEFT OUTER JOIN pv.personDetails" > > I see this as a one-to-many relationship between the Primary Key in > Person_Version and one of the Primary Keys in Person_Details. > > > When I run this it give me the following exception: > > Reason: org.hibernate.AnnotationException: A Foreign key refering > com.PersonDetails from com.PersonVersion > has the wrong number of column. should be 2 > > > I'm only trying to join on the one column. Is this not possible to do? > > TABLES > > PERSON_VERSION > KEY TYPE COLUMN NAME REF TABLE REF COLUMN > > PK_PERSON_VERSION Primary PERSON_VERSION_ID > FK1_PRSN_VRSN Foreign EVENT_ID EVENT EVENT_ID > > > PERSON_DETAILS > > KEY TYPE COLUMN NAME REF TABLE REF COLUMN > > PK_PERSON_DETAILS Primary PERSON_ID, PERSON_VERSION_ID > FK1_PERSON_DTLS Foreign PERSON_VERSION_ID PERSON_VERSION > PERSON_VERSION_ID[/b] > my orm.xml is as follows: > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > My Person_Version class : > > Code: > @Entity > public class PersonVersion extends BaseEntity { > > > private static final long serialVersionUID = 1L; > > > private PersonDetails personDetails; > > ...... > } > -- > View this message in context: > http://n2.nabble.com/Join-with-partial-composite-key-fails-tp3011851p3011851.html > Sent from the OpenJPA Developers mailing list archive at Nabble.com. > -- Sent from my mobile device
