java - 带有对象引用的JPA复合键

使用对象引用创建JPA复合键时遇到了一些问题。实体如下所示

1）我想从Workflow实体中删除ID字段，并通过结合seqNo字段和template（对象引用）字段来制作组合键

2）根据该更改，更新了与Command实体的现有关系（@JoinColumn（name =“ WORKFLOW_ID”，referencedColumnName =“ ID”））

谢谢。

模板实体：

@Entity
@Table(name = "template")
public class Template implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    @SequenceGenerator(name="template_se", sequenceName="TEMPLATE_SE", allocationSize=1, initialValue=1)
    @Basic(optional = false)
    @Column(name = "ID")
    private Integer id;

    @Basic(optional = false)
    @Column(name = "NAME", unique = true)
    private String name;

    @OneToMany(cascade = CascadeType.REMOVE, mappedBy = "template")
    @LazyCollection(LazyCollectionOption.FALSE)
    private List<Workflow> workflowList;
}

工作流程实体：

@Entity
@Table(name = "workflow")
public class Workflow implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    @SequenceGenerator(name="wf_se", sequenceName="WF_SE", allocationSize=1, initialValue=1)
    @Basic(optional = false)
    @Column(name = "ID")
    private Integer id;

    @Basic(optional = false)
    @Column(name = "SEQ_NO")
    private int seqNo;

    @JoinColumn(name = "T_ID", referencedColumnName = "ID", nullable = false)
    @ManyToOne
    private Template template;

    @Basic(optional = false)
    @Column(name = "NAME")
    private String name;
}

命令实体：

@Entity
@Table(name = "command")
public class Command implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    @SequenceGenerator(name="command_se", sequenceName="COMMAND_SE", allocationSize=1, initialValue=1)
    @Basic(optional = false)
    @Column(name = "ID")
    private Integer id;

    @JoinColumn(name = "WORKFLOW_ID", referencedColumnName = "ID")
    @ManyToOne(optional = false)
    private Workflow workflow;
}

最佳答案

我已经按照以下方式完成了工作。

EmbeddedId类

@Embeddable
public class WorkflowPK implements Serializable {

    @Basic(optional = false)
    @Column(name = "SEQ_NO")
    private int seqNo;

    @JoinColumn(name = "T_ID", referencedColumnName = "ID", nullable = false)
    @ManyToOne
    private Template template;
}

工作流程实体（带有EmbeddedId）

@Entity
@Table(name = "workflow")
public class Workflow implements Serializable {

    @EmbeddedId
    private WorkflowPK id;

    @Basic(optional = false)
    @Column(name = "NAME")
    private String name;
}

具有双向关系的模板实体

@Entity
@Table(name = "template")
public class Template implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    @SequenceGenerator(name="template_se", sequenceName="TEMPLATE_SE", allocationSize=1, initialValue=1)
    @Basic(optional = false)
    @Column(name = "ID")
    private Integer id;

    @Basic(optional = false)
    @Column(name = "NAME", unique = true)
    private String name;

    // Refer the filed "template" inside the Composite key of Workflow entity

    @OneToMany(cascade = CascadeType.REMOVE, mappedBy = "id.template")
    @LazyCollection(LazyCollectionOption.FALSE)
    @OrderBy(value = "id.stepSeqNo")
    private List<Workflow> workflowList;
}

带有JoinColumn参考的命令实体

@Entity
@Table(name = "command")
public class Command implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    @SequenceGenerator(name="command_se", sequenceName="COMMAND_SE", allocationSize=1, initialValue=1)
    @Basic(optional = false)
    @Column(name = "ID")
    private Integer id;

    // Refer the Composite key of Workflow entity

    @ManyToOne(optional = false)
    @JoinColumns ({
            @JoinColumn(name="WORKFLOW_SEQ_NO_ID", referencedColumnName = "SEQ_NO"),
            @JoinColumn(name="WORKFLOW_T_ID", referencedColumnName = "T_ID"),
    })
    private WorkflowStep workflow;
}

关于java - 带有对象引用的JPA复合键，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/23066432/