JPA is duplicating a column when inserting. Multiple columns as primary and foreign key

JPA is duplicating a column when trying to insert (column active) and it does not insert the value in one of the parameter.

The error is the following:

could not execute statement [No value specified for parameter 6.] 
[insert into payment_item 
(account_id,x,y,active,payment_id,active,id) 
values (?,?,?,?,?,?,?)]

The DDL is the followinng (simplfied for the explanation):

CREATE TABLE payment_item (
    id BIGINT,
    payment_id BIGINT NOT NULL,
    active BOOLEAN NOT NULL DEFAULT true ,
    PRIMARY KEY (id, active),
    FOREIGN KEY (payment_id, active) REFERENCES payment (id, active)
) PARTITION BY LIST (active);

The mapping jpa:

public class PaymentItemKey implements Serializable {
    private Long id;

    private Boolean active = true;
}

@Entity
@Table(name = "payment_item")
@IdClass(PaymentItemKey.class)
public class PaymentItemEntity {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "payment_item_generator")
    @SequenceGenerator(name = "payment_item_generator", sequenceName = "payment_item_seq", allocationSize = 1)
    private Long id;

    @Id
    private boolean active = true;

    @ManyToOne
    @JoinColumns({
            @JoinColumn(name = "payment_id", referencedColumnName = "id"),
            @JoinColumn(name = "active", referencedColumnName = "active")
    })
    private PaymentEntity payment;

}

if only works if I remove active from the primary key. But it is necessary because I want to partition the table using active column

Note that if I use Embedded instead of IdClass it gives the same error.

You need to sign in to view this answers

Related Post