多个主键表 - Hibernate NonUniqueObjectException

Question

我有一个带有 2 个主键的表（因此它们的组合应该是唯一的）。架构是这样的：

TABLE="INVOICE_LOGS"
INVOICE_NUMBER  PK  non-null
INVOICE_TYPE    PK  non-null
AMOUNT  

当我尝试一次保留多个记录时，我收到此休眠异常：

原因： javax.persistence.PersistenceException： org.hibernate.NonUniqueObjectException： 具有相同对象的不同对象 标识符值已经是 与会话关联： [...InvoiceLog#110105269]

因此，如果我使用下面的代码，我会得到上面的休眠异常。如果我只保留一条记录，它会很好地工作，但如果我尝试像我想做的那样保留一个集合，它就会失败。

    List<InvoiceLog> logs = getLogs();
    for(OvercounterLogDO log: logs) {
        persist(log);
    }

    public void persist(final Object entity) {
        entityManager.persist(entity);
        entityManager.flush();
    }

hibernate映射类如下：

@Component(InvoiceLog.BEAN_NAME)
@Scope(BeanDefinition.SCOPE_PROTOTYPE)
@Entity
@Table(name = "INVOICE_LOGS", uniqueConstraints = {@UniqueConstraint(columnNames = "INVOICE_NUMBER"),@UniqueConstraint(columnNames = "INVOICE_TYPE")} ) 
public class InvoiceLog implements java.io.Serializable {

    private static final long serialVersionUID = -7576525197897271909L;

    protected static final String BEAN_NAME = "invoiceLog";

    private long invoiceNumber;
    private String invoiceType;
    private Double amount;

    public InvoiceLog(){}

    public InvoiceLog(Integer invoiceNumber, String invoiceType,
            Double amount) {
        super();
        this.invoiceNumber = invoiceNumber;
        this.invoiceType = invoiceType;
        this.amount = amount;
    }

    @Id
    @Column(name = "INVOICE_NUMBER", unique = true, nullable = false, precision = 10, scale = 0)
    public long getInvoiceNumber() {
        return invoiceNumber;
    }
    public void setInvoiceNumber(long invoiceNumber) {
        this.invoiceNumber = invoiceNumber;
    }

//  @Id
    @Column(name = "INVOICE_TYPE", nullable = false, length = 4)
    public String getInvoiceType() {
        return invoiceType;
    }
    public void setInvoiceType(String invoiceType) {
        this.invoiceType = invoiceType;
    }

    @Column(name = "AMOUNT", nullable = false, length = 12)
    public Double getAmount() {
        return amount;
    }
    public void setAmount(Double amount) {
        this.amount = amount;
    }

}

Answer 1

您当前的映射有一个 Id、invoiceNumber，而不是复合键。因此，它要求发票编号是唯一的，而不是您想要的组合。这就是异常告诉您的内容，它注意到您正在尝试保存具有相同 Id 值的第二条记录。

您需要将两个字段映射为复合键。从您对第二个 @Id 的注释来看，您在某个时刻正朝着这个方向前进。 这里是有关映射组合键的方法的文档 。