Shared primary key generation. Hibernate

Question

I'm having problems with generating primary keys with one-to-one relations that use shared primary key.

Here's code:

@Entity
@Table(name = "osoba")
public class Osoba implements Serializable
{

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "osoba_id")
    private Integer osobaId;

    @PrimaryKeyJoinColumn
    @OneToOne(cascade = CascadeType.PERSIST)
    public Pracownik pracownik;
...

and second class:

@Entity
@Table(name = "pracownik")
public class Pracownik
{ 
    @OneToOne
    @JoinColumn(name = "osoba_id")
    @MapsId("osobaId")
    private Osoba osoba;

    @Id
    @Column(name = "osoba_id")
    private Integer osobaId;
...

I've been similar issues and I thought that i've done everything correctly but i still get

org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save(): entity.Pracownik

when trying to persist Pracownik objects.

score 0 · Answer 1 · answered Feb 02 '14 at 16:07

You need to follow example from @MapsId documentation (in your case, with @Id instead of @EmbeddedId):

@Entity
@Table(name = "pracownik")
public class Pracownik {
    @Id 
    @Column(name = "oboba_id")
    private Integer id;

    @OneToOne
    @MapsId
    private Osoba osoba;

    ...
}

Inverse side of @OneToOne relationship should be mapped with mappedBy, as usually:

@Entity
@Table(name = "osoba")
public class Osoba implements Serializable {
    ...
    @OneToOne(mappedBy = "osoba", cascade = CascadeType.PERSIST)
    public Pracownik pracownik;
    ...
}

Sorry, I forgot to paste the part of code with id in `Pracownik`. Now it's edited. I also replaced `@PrimaryKeyJoinColumn` with `mappedBy = "osoba"`. But the error still exists. — Tuan Pham, Feb 02 '14 at 16:19

score 0 · Answer 2 · answered Dec 16 '15 at 11:14

This old question but it works for me. Mayby it will help someone.

SQL Script (Oracle)

DROP TABLE HIBERNATE.PRACOWNIK;
DROP TABLE HIBERNATE.OSOBA;
DROP SEQUENCE HIBERNATE.OSOBA_SEQ;

CREATE TABLE HIBERNATE.OSOBA (
osoba_id                                NUMBER(15),
CONSTRAINT OSOBA_PK PRIMARY KEY (osoba_id)
);

CREATE TABLE HIBERNATE.PRACOWNIK (
    pracownik_id                                NUMBER(15),
    CONSTRAINT PRACOWNIK_PK PRIMARY KEY (pracownik_id),
    CONSTRAINT PRACOWNIK_FK FOREIGN KEY (pracownik_id) REFERENCES OSOBA(osoba_id)
);

CREATE SEQUENCE HIBERNATE.OSOBA_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

Osoba.java

@Entity
@Table(name = "osoba")
public @Data class Osoba {

    @Id
    @Column(name = "osoba_id")
    @GeneratedValue(generator="osoba-generator", strategy = GenerationType.SEQUENCE)
    @SequenceGenerator(name="osoba-generator", allocationSize = 1, sequenceName = "OSOBA_SEQ")
    private Long osobaId;

    @OneToOne(fetch=EAGER, mappedBy="osoba", cascade=ALL)
    private Pracownik pracownik;
}

Pracownik.java

@Entity
@Table(name="pracownik")
public @Data class Pracownik {

    @Id
    @Column(name = "pracownik_id")
    @GeneratedValue(generator="pracownik-generator")
    @GenericGenerator(name="pracownik-generator", strategy="foreign", parameters=
        @Parameter(name = "property", value = "osoba")
    )
    private Long pracownikId;

    @OneToOne(fetch=FetchType.EAGER)
    @PrimaryKeyJoinColumn
    private Osoba osoba;

}

@Data is Lombok

Shared primary key generation. Hibernate

2 Answers2