冬眠。给出“org.hibernate.PersistentObjectException分离实体传递到Persistent”错误的多对多

Question

{
"name" : "SC1",
"address" : "Street 1111",
"description" : "A Sport center",
"email" : "[e-mail]",
"phones" : [{"number" : "123456"}, {"number" : "654321"}],
"services" : [{"idService" : 1}, {"idService" : 2}],
"commune" : {"idCommune" : 1},
"users" : [{"idUser":62}]
}

2018-06-25 03:56:32.670 DEBUG 20696 --- [nio-8080-exec-6] org.hibernate.SQL                        : insert into sport_center (address, Commune_idCommune, description, email, name) values (?, ?, ?, ?, ?)
2018-06-25 03:56:32.671 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [VARCHAR] - [Street 1111]
2018-06-25 03:56:32.671 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [INTEGER] - [1]
2018-06-25 03:56:32.671 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [3] as [VARCHAR] - [A Sport center]
2018-06-25 03:56:32.671 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [4] as [VARCHAR] - [[e-mail]]
2018-06-25 03:56:32.671 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [5] as [VARCHAR] - [SC1]
2018-06-25 03:56:32.800 DEBUG 20696 --- [nio-8080-exec-6] org.hibernate.SQL                        : insert into phone (number, Sport_center_idSport_Center) values (?, ?)
2018-06-25 03:56:32.800 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [123456]
2018-06-25 03:56:32.800 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [INTEGER] - [252]
2018-06-25 03:56:32.942 DEBUG 20696 --- [nio-8080-exec-6] org.hibernate.SQL                        : insert into phone (number, Sport_center_idSport_Center) values (?, ?)
2018-06-25 03:56:32.942 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [1] as [BIGINT] - [654321]
2018-06-25 03:56:32.942 TRACE 20696 --- [nio-8080-exec-6] o.h.type.descriptor.sql.BasicBinder      : binding parameter [2] as [INTEGER] - [252]
2018-06-25 03:56:33.368 ERROR 20696 --- [nio-8080-exec-6] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.dao.InvalidDataAccessApiUsageException: detached entity passed to persist: com.eiffel.canchai.model.Service; nested exception is org.hibernate.PersistentObjectException: detached entity passed to persist: com.eiffel.canchai.model.Service] with root cause

org.hibernate.PersistentObjectException: detached entity passed to persist: com.eiffel.canchai.model.Service

我的课程如下：

sportcenter.java

@Entity
@Table(name = "sport_center")
public class SportCenter implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)    
@Column(name = "idSport_Center")
private Integer idSportCenter;

@Column(name = "name")
private String name;

@Column(name = "address")
private String address;

@Column(name = "description")
private String description;

@Column(name = "email")
private String email;

@JoinTable(name = "sport_center_has_user", joinColumns = {
    @JoinColumn(name = "Sport_center_idSport_Center", referencedColumnName = "idSport_Center")}, inverseJoinColumns = {
    @JoinColumn(name = "User_idUser", referencedColumnName = "idUser")})
@ManyToMany(cascade = CascadeType.ALL)
private List<User> users;


@JoinTable(name = "sport_center_has_service", joinColumns = {
@JoinColumn(name = "Sport_center_idSport_Center", referencedColumnName = "idSport_Center")}, inverseJoinColumns = {    
@JoinColumn(name = "Service_idService", referencedColumnName = "idService")})
@ManyToMany(cascade = CascadeType.ALL)    
private List<Service> services;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "sportCenter")
@JsonIgnore
private List<ImageField> imageFields;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "sportCenter")
@JsonIgnore
private List<Field> fields;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "sportCenter", fetch = FetchType.LAZY)
private List<Phone> phones;

@JoinColumn(name = "Commune_idCommune", referencedColumnName = "idCommune")
@ManyToOne(optional = false)    
private Commune commune;


public SportCenter() {
}

service.java

@Entity
@Table(name = "service")
public class Service implements Serializable {

private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)    
@Column(name = "idService")
private Integer idService;

@Column(name = "name")
private String name;           

@ManyToMany(fetch = FetchType.LAZY, mappedBy = "services", cascade = CascadeType.ALL) 
@JsonIgnore
private List<SportCenter> sportCenters;

public Service() {
}

@Repository
@Transactional
public class ServiceDao implements IServiceDao {

@PersistenceContext
private EntityManager entityManager;

@Override
public void save(Service entity) {
    entityManager.persist(entity);      
}

@Controller
@RequestMapping("/sportcenter")
@CrossOrigin
public class SportCenterController {

@Autowired
private ISportCenterService  sportCenterService;

@PostMapping("/register")
public ResponseEntity<?> registerSportCenter(@RequestBody SportCenter sc){      
    if (sc.getEmail().length() == 0 || sc.getName().length() == 0 || sc.getAddress().length() == 0 || sc.getPhones().size() == 0 || sc.getServices().size() == 0) {
        return new ResponseEntity(new ErrorMsg("Check parameters. One of them is missing"),HttpStatus.NO_CONTENT);
    }

    for (Phone p : sc.getPhones()) {
        p.setSportCenter(sc);           
    }

    for (Service s : sc.getServices()) {
        s.addSportCenters(sc);              
    }

    sportCenterService.save(sc);
    return new ResponseEntity(HttpStatus.OK);
}

提前道谢！

Answer 1

这里的问题是，您正在将persist事件从父级级联到子级。

当子实体具有非零ID时，hibernate将假定它已经存在。因为您是从rest服务获取数据，所以我猜子“服务”实体没有分离。因此出现错误“已分离的实体传递到持久”。

您需要首先持久化父实体，通过合并调用管理子实体，然后将父实体链接到子实体，或者删除cascade.all。