报错信息:
2023-06-26 15:29:48,163 ERROR [http-nio-18082-exec-1] [AlyYJCWnxQG] c.j.s.e.DefaultExceptionHandler: Catch Exception:
org.springframework.orm.jpa.JpaSystemException: identifier of an instance of com.jinkun.app.entity.MonthCard was altered from ef60cb79-d84b-dfs3-b8bf-fc123ac0d7ac to 1409fe65-2b87-3342-86cd-c5e75783fd8d; nested exception is org.hibernate.HibernateException: identifier of an instance of com.jinkun.app.entity.MonthCard was altered from ef60cb79-d84b-dfs3-b8bf-fc123ac0d7ac to 1409fe65-2b87-3342-86cd-c5e75783fd8d
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:331) ~[spring-orm-5.3.7.jar:5.3.7]
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:233) ~[spring-orm-5.3.7.jar:5.3.7]`
报错源码:
//查询月卡,然后修改用户,插入数据。
monthCardRepository.findByUser(it).ifPresent(list -> {
List<MonthCard> cloneList = new ArrayList<>();
list.forEach(card -> {
card.setId(UUID.randomUUID());//关键就是这里导致的报错,因为修改了查询结果对象的ID。
MonthCard clone = card.clone();
clone.setUser(user);
cloneList.add(clone);
});
monthCardRepository.saveAll(cloneList);
});
Hibernate会在同个会话内让查询出来的对象,其属性值与数据库字段值保持一致,这也是不能修改原对象ID的原因。解决办法很简单,先克隆原有对象后,再修改克隆对象的属性即可(使用new
关键字新建对象也是一样的)。
list.forEach(card -> {
MonthCard clone = card.clone();
clone.setId(UUID.randomUUID());
clone.setUser(user);
cloneList.add(clone);
});
monthCardRepository.saveAll(cloneList);