删除未完成

Question

我使用spring Boot2、jpa和Hibernate。Db是后置，我尝试删除一个带有子级的对象

@Entity
@IdClass(SamplingsPK.class)
@Inheritance(strategy = InheritanceType.SINGLE_TABLE)
public class Samplings {

    @Id
    private int year; //only last 2 number 2018 -> 18

    @Id
    @GeneratedValue
    private Integer sequenceId;

    @OneToOne
    private Colors color;

    @OneToMany(mappedBy = "sampling", cascade = CascadeType.ALL, orphanRemoval = true)
    private List<Samples> samples = new ArrayList<>();

    @Embedded
    private TestSamplings testSamplings;

    ...
}

public class SamplingsPK implements Serializable {

    private int year;

    private Integer sequenceId;

    public SamplingsPK(int year, Integer sequenceId) {
        this.sequenceId = sequenceId;
        this.year = year;
    }

    private SamplingsPK() {

    } 
    ...
}

@Entity
@IdClass(SamplesPK.class)
public class Samples{

    @Id
    private String sampleLetter;

    @Id
    @ManyToOne(optional = false)
    @JoinColumns({
        @JoinColumn(name = "sampling_id", referencedColumnName = "sequenceId"),
        @JoinColumn(name = "sampling_year", referencedColumnName = "year")})
    private Samplings sampling;

    @OneToOne(mappedBy = "sample", cascade = CascadeType.ALL, fetch = FetchType.LAZY, orphanRemoval = true)
    private TestSamples testSamples;
    ...
}


@Entity
public class TestSamples {

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

    @OneToOne(fetch = FetchType.LAZY)
    private Samples sample;

    @OneToOne(mappedBy = "testSample", fetch = FetchType.LAZY, cascade = CascadeType.ALL, orphanRemoval = true)
    private Compressions compressionTest;
    ....
}

@Repository
public interface SamplingsRepository extends JpaRepository<Samplings, SamplingsPK> {
}

如果我删除了Samplings，Samplings、testsamplings和Compressions也应该被删除。

@Transactional
public void deleteSamplings(int year, Integer id) {
    samplingsRepository.deleteById(new SamplingsPK(year, id));

}

从sample_letter=？的示例中删除和sampling_id=？和sampling_year=？

2018-10-03 22:21:05.832错误14511--[nio-8080-exec-9]O.H.I.ExceptionMapperStandardmpl:HHH000346:托管刷新期间出错[批处理更新从更新[0]返回意外行计数；实际行数：0；应为：1]2018-10-03 22:21:05.834信息14511---[nio-8080-exec-9]O.H.E.J.B.Internal.AbstractBatchImpl:HHH000010:批处理释放时仍包含JDBC语句2018-10-03 22:21:05.848错误14511---[nio-8080-exec-9]O.A.C.C.C.[.[/].[dispatcherServlet]:路径为[]的上下文中servlet[dispatcherServlet]的servlet.Service（）引发异常[请求处理失败；嵌套异常为

没有sample和其他的查询

只需搜索一种删除所有东西的方法...

Answer 1

这很可能是因为您正在尝试更新/删除一些没有区别或不再存在的东西。

此外，如果使用任何生成器类，则不应使用setter显式设置ID属性（这似乎不是您的情况）。

如果显式设置Id属性的值，则会导致此错误。在Hibernate映射文件中签入字段generator=“native”或“incremental”，并且在数据库中映射的表不是auto_incremented。

还要尝试更新表以设置auto_increment