OneToMany插入导致分离实体传递到持久化错误

Question

return Panache.withTransaction(() -> {
            return featuresRepository.findByIds(ids).collect().asList().onItem().transform(t -> {
                FeatureRole fr = new FeatureRole();
                fr.setRole_name("role name");
                for (Features fe: t) {
                    fr.setFeatures(fe);
                    fe.getFeatureRoles().add(fr);
                }
                return featureRoleRepository.persistAndFlush(fr).map(to -> fr);
            }).flatMap(t -> t);
        });

Caused by: java.util.concurrent.CompletionException: org.hibernate.PersistentObjectException: detached entity passed to persist: io.github.jithset.models.Features
                at java.base/java.util.concurrent.CompletableFuture.encodeThrowable(CompletableFuture.java:331)
                at java.base/java.util.concurrent.CompletableFuture.uniApplyNow(CompletableFuture.java:670)
                at java.base/java.util.concurrent.CompletableFuture.uniApplyStage(CompletableFuture.java:658)
                at java.base/java.util.concurrent.CompletableFuture.thenApply(CompletableFuture.java:2094)
                at java.base/java.util.concurrent.CompletableFuture.thenApply(CompletableFuture.java:143)
                at org.hibernate.reactive.util.impl.CompletionStages.lambda$loop$5(CompletionStages.java:170)
                at com.ibm.asyncutil.iteration.AsyncTrampoline.lambda$asyncWhile$1(AsyncTrampoline.java:209)
                at com.ibm.asyncutil.iteration.AsyncTrampoline$TrampolineInternal.unroll(AsyncTrampoline.java:119)
                at com.ibm.asyncutil.iteration.AsyncTrampoline$TrampolineInternal.trampoline(AsyncTrampoline.java:101)
                at com.ibm.asyncutil.iteration.AsyncTrampoline$TrampolineInternal.access$200(AsyncTrampoline.java:84)
                at com.ibm.asyncutil.iteration.AsyncTrampoline.asyncWhile(AsyncTrampoline.java:192)
                at com.ibm.asyncutil.iteration.AsyncTrampoline.asyncWhile(AsyncTrampoline.java:209)
                at org.hibernate.reactive.util.impl.CompletionStages.loop(CompletionStages.java:169)
                at org.hibernate.reactive.util.impl.CompletionStages.loop(CompletionStages.java:186)
                at org.hibernate.reactive.session.impl.ReactiveSessionImpl.fire(ReactiveSessionImpl.java:1076)
                at org.hibernate.reactive.session.impl.ReactiveSessionImpl.firePersist(ReactiveSessionImpl.java:696)
                ... 67 more

特征角色

@Entity
@Table(name = "feature_role")
public class FeatureRole {

    @Id
    @SequenceGenerator(name = "featureRoleSeq", sequenceName = "featureRoleSeq", allocationSize = 1)
    @GeneratedValue(generator = "featureRoleSeq")
    private Long id;

    @ManyToOne(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    @JoinColumn(name = "features_id", nullable = false)
    @Getter @Setter
    @JsonbTransient
    private Features features;

    @Getter @Setter
    private String role_name;

}

特征

@Entity
@Table(name = "features")
@NoArgsConstructor
@ToString
public class Features {

    @Id
    @SequenceGenerator(name = "featureSequence", sequenceName = "featureSequence", allocationSize = 1)
    @GeneratedValue(generator = "featureSequence")
    @Column(name = "feature_id")
    @Getter @Setter
    public Long id;

    @Getter @Setter
    @NotBlank
    @Column(unique = true)
    public String name;

    @OneToMany(
            mappedBy = "features",
            cascade = CascadeType.ALL,
            orphanRemoval = true,
            fetch = FetchType.EAGER
    )
    @Getter @Setter
    private List<FeatureRole> featureRoles =new ArrayList<>();

    public Features(Long id, String name) {
        this.id = id;
        this.name = name;
    }

    public static Features from(Row row) {
        return new Features(row.getLong("feature_id"), row.getString("name"));
    }`enter code here`

Answer 1

根据您的映射，featurerole可以与单个feature关联（多对一）。在代码中，每次调用fr.setfeatures(fe)；时，都要遍历多个特性并重写关联。

这意味着只有循环中最后的特性才具有正确的关联，因为fr只与单个元素关联。

假设一个features可以有许多featurerole，您需要决定应用哪个用例：

...
class FeatureRole {
    ...
    @ManyToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL)
    private List<Features> features;
    ...
    public void addFeature(Features features) {
     this.features.add( features );
     features.getFeatureRoles().add( this );
 }

...
class Features {
    ...
    @ManyToMany(mappedby="features")
    private List<FeatureRole> featureRoles =new ArrayList<>()
    ...
}

for (Features fe: t) {
    fr.addFeatures(fe);
}