0

How to generate id when there are composite keys in entity spring boot, I have make composite primary key using IdClass but it don't go well when I try to insert generated value from Spring Boot

@Entity
@DynamicUpdate
@DynamicInsert
@Table(name = "tm_trx_flow")
@IdClass(TmTrxFlowSerializable.class)
public class TmTrxFlow {
    @Id
    @Column(name ="tm_trx_procedure_id")
    private Integer tmTrxProcedureId;
    
    @Id     
    @SequenceGenerator(name = "some_seq", sequenceName = "empid_seq")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "some_seq")
    @Column(name="tm_trx_flow_id")
    private Integer tmTrxFlowId;
    
}
James Graham
  • 39,063
  • 41
  • 167
  • 242
Adam Abdullah
  • 37
  • 8

1 Answers1

0

primary key (composite keys) cannot auto generated.

James Graham
  • 39,063
  • 41
  • 167
  • 242
  • what is the best practice to get value for primary key from composite keys ? – Adam Abdullah Nov 18 '21 at 08:24
  • You can use `@EmbeddedId` https://www.baeldung.com/jpa-composite-primary-keys ; https://stackoverflow.com/questions/13032948/how-to-create-and-handle-composite-primary-key-in-jpa – James Graham Nov 18 '21 at 08:43