Primary key which also is a foreign key

K@sperl · **Joined:** Thu Dec 14, 2006 11:17 am **Posts:** 9

Hello,

I'm trying to set up a primary key which also is an foreign key.

Consider the following example:

Code:

@Entity
public class Person {
  private Long personID;
  
  @Id
  public Long getPersonID() {
    return personID;
  }
  public void setPersonID(Long id) {
    this.personID = id;
  }
}

And the class where personID should be both primary and foreign key:

Code:

@Entity
public class PersonData {
  private Person person;

  @Id
  @ManyToOne
  @JoinColumn(name="personID")
  public Person getPerson() {
    return person;
  }
...
}

In the DB in table PersonData the field isn't named personID but person. It's not a foreign key, it's a simple varbinary.

What is wrong in the above code?

Thanks,
Kasperl

cbredesen · **Posted:** Wed Jul 11, 2007 4:55 pm

Looks like you should be doing OneToOne and PrimaryKeyJoinColumn:
http://www.hibernate.org/hib_docs/annot ... tml#d0e998

And, you better make sure the mapping properly reflects the name and data type.

HTH,

Chris