springData jpa中@Query的delete删除出现问题

错误信息：

部分错误信息：

org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [delete from com.lsc.pojo.User u where u.id=?1]; nested exception is java.lang.IllegalStateException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [delete from com.lsc.pojo.User u where u.id=?1]

出现这个错误的原因是因为我的自定义方法中没有加入 @Modifying这个注解。

    //删除用户
  
    @Transactional
    @Query("delete from User u where u.id=?1")
    int DeleteUser(int id);

只要把@Modifying注解加上

    //删除用户
    @Modifying
    @Transactional
    @Query("delete from User u where u.id=?1")
    int DeleteUser(int id);

这样问题就可以迎刃而解了。