CODEWITHSUNDEEP
hibernateforeign-keyscomposite-primary-key
rascio
rascio

Reputation: 9279

Hibernate foreign key as part of primary key


I have to work with hibernate and not very sure how solve this problem, I've 2 table with a 1..n relationship like this:

-------
TABLE_A
-------
first_id (pk)
second_id (pk)
[other fields]

-------
TABLE_B
-------
first_id (pk)(fk TABLE_A.first_id)
second_id (pk)(fk TABLE_A.second_id)
third_id (pk)
[other fields]

How can I manage this with Hibernate???

I don't have idea how to manage the primary key for the second table...

Upvotes: 10

Views: 37887

Answers (4)

Amby
Amby

Reputation: 462

For Table A you can make you of embeddedId

@Emebddable
class PrimaryKeyIdTableA{
 private Integer firstId,

 private Integer secondId
}


class A {
 @EmebddedId
 private PrimaryKeyIdTableA id
}

For Table B you can use Idclass also as shown below

Class PrimaryKeyIdTableB {

private PrimaryKeyIdTableA id,

private Integer thirdId

 }

 @Idclass(PrimaryKeyIdTableB.class)
 Class TableB{
 @Id
 private Integer thirdId,
 
  @Id
  @onetoone
  @Joincolumns({
  @Joincolumn(name=firstid),
  @Joincolumn(name=secondId)})
 private PrimaryKeyIdTableA id
    }

Upvotes: 0

Sandy
Sandy

Reputation: 9

public class User implements Serializable {
    /**
     * 
     */
    private static final long serialVersionUID = 5478661842746845130L;
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private int id;
}
@Entity
public class Author {

    @Id
    @Column(name = "AUTHOR_ID", nullable = false)
    private int authorId;
    @Column(name = "ENABLED", nullable = false, length = 1)
    private boolean enabled;

    @OneToOne
    @MapsId
    @JoinColumn(name = "AUTHOR_ID", referencedColumnName = "ID", nullable = false, insertable = false, updatable = false)
    User user;

    public boolean isEnabled() {
        return enabled;
    }

    public void setEnabled(boolean enabled) {
        this.enabled = enabled;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

}

Upvotes: 0

JB Nizet
JB Nizet

Reputation: 691755

There is an example which is completely similar to your case in the Hibernate reference documentation. Just before this example, you'll find the explanations. Here's the example, which matches your problem (User is table A, and Customer is table B):

@Entity
class Customer {
   @EmbeddedId CustomerId id;
   boolean preferredCustomer;

   @MapsId("userId")
   @JoinColumns({
      @JoinColumn(name="userfirstname_fk", referencedColumnName="firstName"),
      @JoinColumn(name="userlastname_fk", referencedColumnName="lastName")
   })
   @OneToOne User user;
}

@Embeddable
class CustomerId implements Serializable {
   UserId userId;
   String customerNumber;

   //implements equals and hashCode
}

@Entity 
class User {
   @EmbeddedId UserId id;
   Integer age;
}

@Embeddable
class UserId implements Serializable {
   String firstName;
   String lastName;

   //implements equals and hashCode
}

Note: it would be much much simpler of you had a surrogate identifier for those two tables. Unless you're forced to deal with a legacy schema, do yourself a favor and use surrogate keys.

Upvotes: 20

Tomasz Nurkiewicz
Tomasz Nurkiewicz

Reputation: 340733

Use @PrimaryKeyJoinColumn and @PrimaryKeyJoinColumns annotations. From Hibernate manual:

The @PrimaryKeyJoinColumn annotation does say that the primary key of the entity is used as the foreign key value to the associated entity.

Upvotes: 4

Related Questions