传递给持久化JPA Spring Boot保存的分离实体

Question

@Entity
@Table(name = "NPRO_USUARIOS")
public class User implements Serializable {

    private static final long serialVersionUID = -1330075515340995797L;

    @Id
    @GeneratedValue(strategy=GenerationType.AUTO, generator="user_seq_gen")
    @SequenceGenerator(name="user_seq_gen", sequenceName="TELCO_NPRO_USER_SEQ")
    @NotNull
    private int id_usuario;

    @NotNull
    private String nombre_usuario;

    @ManyToMany(cascade = {CascadeType.PERSIST,CascadeType.REMOVE, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
    @JoinTable(name = "NPRO_USUARIOS_SOCIEDADES_AREAS", joinColumns = @JoinColumn(name = "id_usuario"), inverseJoinColumns = @JoinColumn(name = "id_sociedad"))
    private Set<Sociedad> listaSociedad;

    @Transient
    private String sociedades;

    // Si el area es nula, el usuario estara asignado a todas las areas
    @ManyToMany(cascade = {CascadeType.PERSIST,CascadeType.REMOVE, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
    @JoinTable(name = "NPRO_USUARIOS_SOCIEDADES_AREAS", joinColumns = @JoinColumn(name = "id_usuario"), inverseJoinColumns = @JoinColumn(name = "id_area"))
    private Set<Area> listAreas;

    @Transient
    private String areas;

    @NotNull
    private String matricula_usuario;

    @NotNull
    private String email_usuario;

    @ManyToMany(cascade = { CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
    @JoinTable(name = "NPRO_PERFILES_USUARIOS", joinColumns = @JoinColumn(name = "id_usuario"), inverseJoinColumns = @JoinColumn(name = "id_rol"))
    private Set<Role> listaRoles;

    @ManyToMany(cascade = { CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
    @JoinTable(name = "NPRO_PERFILES_USUARIOS", joinColumns = @JoinColumn(name = "id_usuario"), inverseJoinColumns = @JoinColumn(name = "id_pantalla"))
    private Set<Pantalla> listaPantallas;

    private LocalDateTime fecha_ultimo_acceso;
    private String observaciones;

    @JsonIgnore
    @ManyToOne
    @JoinColumn(name = "usuario_modif")
    private User usuario_modif;
}

@Entity
@Table(name = "NPRO_MAESTRO_SOCIEDADES")
public class Sociedad implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @NotNull
    private int id_sociedad;
    @NotNull
    private String cod_sociedad;
    @NotNull
    private String cod_sociedad_gl;
    @NotNull
    private String nombre_sociedad;
    @NotNull
    private String cif_sociedad;
    private String observaciones;

    @JsonIgnore
    @ManyToOne
    @JoinColumn(name = "usuario_modif")
    private User usuario_modif;

    private String activo;

    @JsonIgnore
    @ManyToMany(cascade = {CascadeType.PERSIST,CascadeType.REMOVE, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
    @JoinTable(name = "NPRO_USUARIOS_SOCIEDADES_AREAS", joinColumns = @JoinColumn(name = "id_sociedad"), inverseJoinColumns = @JoinColumn(name = "id_usuario"))
    private Set<User> listaUsuarios;
}

@Entity
@Table(name = "NPRO_MAESTRO_AREAS")
public class Area implements Serializable {

    private static final long serialVersionUID = -1330075515340995797L;
    @Id
    @GeneratedValue(strategy=GenerationType.AUTO, generator="area_seq_gen")
    @SequenceGenerator(name="area_seq_gen", sequenceName="TELCO_NPRO_AREAS_SEQ")
    @NotNull
    private int id_area;

    @NotNull
    private String nombre_area;

    private LocalDateTime fecha_modif;
    private String observaciones;

    @JsonIgnore
    @ManyToOne
    @JoinColumn(name = "usuario_modif")
    private User usuario_modif;

    @NotNull
    private String activo;

    @ManyToOne
    @JoinColumn(name="id_sociedad")
    private Sociedad sociedad;

    @JsonIgnore
    @ManyToMany(cascade = {CascadeType.PERSIST,CascadeType.REMOVE, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
    @JoinTable(name = "NPRO_USUARIOS_SOCIEDADES_AREAS", joinColumns = @JoinColumn(name = "id_area"), inverseJoinColumns = @JoinColumn(name = "id_usuario"))
    private Set<User> listaUsuarios;
    }

我正在使用springboot jpa存储库保存方法

@Override
public User save(User user) {

    return userRepository.save(user);
}

这是完整的错误:2020-06-09 15:49:02.371[nio-8080-exec-4]。M.M.A.ExceptionHandlerExceptionResolver：由处理程序执行导致的解析异常：org.springframework.dao.invalidDataAccessapiusageException：传递给persistent的分离实体：com.telefonica.npro.model.area；嵌套异常是org.hibernate.persistentObjectException：传递给persist:com.telefonica.npro.model.area的分离实体

提前致谢

编辑：

我在http://knowledgespleasure.blogspot.com/2015/06/condernand-detached-entity-passs-to.html这一页上读到了关于eror的内容

我想我的问题是最后一个：

另一方面，如果requirement不是在DB中添加新的子级，则应删除cascadetype.persist，并使用cascade={cascadetype.merge,cascadetype.refresh}

用户总是与公司和地区相关联的，他们已经存在，他们不会是新的。但是，如果我删除PERSIST，在commun表npro_usuarios_sociedades_areazes中插入一个id null是很麻烦的

有人帮忙吗？

Answer 1

我将解释用户和区域实体之间的@manytomany双向关系的问题。

>

双向@manytomany关联应该有一个owning和mappedby端。CascadeType应该只存在于此关联的一侧。

正如本文所解释的，您需要使双方同步，否则，您将破坏域模型关系的一致性，并且除非双方正确同步，否则不能保证实体状态转换工作。因此，User实体定义了AddArea和RemoveArea实体状态同步方法。

因此，应该以以下方式更正用户区域@manytomany映射：

@Entity
@Table(name = "NPRO_USUARIOS")
public class User implements Serializable {
   // ...

   @ManyToMany(cascade = {CascadeType.PERSIST,CascadeType.REMOVE, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH })
   @JoinTable(name = "NPRO_USUARIOS_SOCIEDADES_AREAS", joinColumns = @JoinColumn(name = "id_usuario"), inverseJoinColumns = @JoinColumn(name = "id_area"))
   private Set<Area> listAreas;

   public User()
   {
      listAreas = new HashSet<>();
   }

   public void addArea(Area area) {
      listAreas.add(area);
      area.getUsers().add(this);
   }

   public void removeArea(Area area) {
      listAreas.remove(area);
      area.getUsers().remove(this);
   }
}

@Entity
@Table(name = "NPRO_MAESTRO_AREAS")
public class Area implements Serializable {
    // ... 

    @JsonIgnore
    @ManyToMany(mappedBy = "listAreas")
    private Set<User> listaUsuarios;
}

然后可以通过以下方式保存一个新用户：

   User user = new User();
   // ...
   Area area1 = new Area();
   // ...
   user.addArea(area1);

   Area area2 = new Area();
   // ...
   user.addArea(area2);

   userRepository.save(user);

应该对用户-社会关系进行类似的更正。