猿问

JPA persist 在级联子项时插入不正确的 id 值

这段代码失败了我在数据库中有一个现有的版本化值,我使用 获取该值entity manager.find并在实体上设置。


VersionEntity version = entityManager.find(VersionEntity.class, 1);

entities.forEach(__ -> __.setVersion(version));

entities.forEach(entityManager::persist);

entityManager.flush();

我专门查找并分配版本 1,那么为什么它甚至会尝试使用版本 2。我什至尝试过merge,但没有奏效。我的属性显然是错误的/不正确的。


刷新失败


本地异常堆栈:异常 [EclipseLink-4002](Eclipse 持久性服务 - 2.7.1.qualifier):org.eclipse.persistence.exceptions.DatabaseException 内部异常:org.postgresql.util.PSQLException:错误:插入或更新表“ t_quality_measurement”违反外键约束“fk_t_quality_measurement_version” 详细信息:表“t_version”中不存在键(版本)=(2)。错误代码:0 调用:INSERT INTO T_QUALITY_MEASUREMENT (BRAND, DATE, KPICODE, KPICOMPAREVW, KPICOMPAREWT, KPIVALUE, ORGANISATIONUNIT, PHASE, PLANT, SERIES, SIGNALCOLOR, TECHNOLOGY, TEMPORALUNIT, (?, S?) ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [14 个参数绑定] 查询:


当我专门查找 1 时,我不确定为什么它会尝试使用 2。


@Entity

@Table(name = "T_QUALITY_MEASUREMENT")

public class QualityMeasurementEntity extends Versioned implements Serializable {


    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    @Column(columnDefinition = "serial")

    private Integer id;


    @Column(length = 100)

    private String series;

版本化看起来像这样


@MappedSuperclass

public abstract class Versioned {

    @ManyToOne

    @JoinColumn(name = "version", insertable = false, updatable = false)

    protected VersionEntity version = null;


    public VersionEntity getVersion() { return version; }


    public void setVersion(VersionEntity version) { this.version = version; }

}

和版本实体。


@Entity

@Table(name = "T_VERSION", indexes = {

        @Index(name = "pk_version", columnList = "id", unique = true)

})

@NamedQuery(name = "Version.findById", query = "SELECT v FROM VersionEntity v WHERE v.id = :id")

public class VersionEntity {


    @Id

    @GeneratedValue(strategy = GenerationType.IDENTITY)

    @Column(columnDefinition = "serial")

    private Integer id;


    @Column(name = "CREATED")

    private LocalDateTime created;

UYOU
浏览 216回答 1
1回答
随时随地看视频慕课网APP

相关分类

Java
我要回答