Spring data jpa 自定义SQL语句遇到错误Not supported for DML operations

最新推荐文章于 2020-12-11 09:59:00 发布

小船长的炒菜猫

最新推荐文章于 2020-12-11 09:59:00 发布

阅读量2.5k

点赞数

分类专栏： Spring Data Jpa 文章标签： spring jpa sql

本文链接：https://blog.csdn.net/u010429286/article/details/52150805

版权

Spring Data Jpa 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

今天在自定义一个Update语句时运行遇到一个错误，显示Not supported for DML operations 也就是说不支持DML操作。我的UserRepository是继承的PagingAndSortingRepository接口，在看了JPA的文档之后，发现此接口不支持update事务，所以需要在注解上添加@Modifying。

原文如下：

3.3.7. Modifying queries

All the sections above describe how to declare queries to access a given entity or collection of entities.Of course you can add custom modifying behaviour by using facilities described in Customimplementations for Spring Data repositories. As this approach is feasible for comprehensive customfunctionality, you can achieve the execution of modifying queries that actually only need parameterbinding by annotating the query method with @Modifying:

Example 45. Declaring manipulating queries

    @Modifying
    @Query("update User u set u.firstname = ?1 where u.lastname = ?2")
    int setFixedFirstnameFor(String firstname, String lastname);

This will trigger the query annotated to the method as updating query instead of a selecting one. As theEntityManager might contain outdated entities after the execution of the modifying query, we do notautomatically clear it (see JavaDoc of EntityManager.clear() for details) since this will effectively dropall non-flushed changes still pending in the EntityManager. If you wish the EntityManager to be clearedautomatically you can set @Modifying annotation’s clearAutomatically attribute to true.

以下是我的源码：

@Modifying
@Query("update User u set u.u_name=?2,u.u_sex=?3,u.u_date = ?4,u.u_minzu = ?5,u.u_area=?6,u.u_country=?7 where u.u_id =?1")
public void updateUserById(String u_id,String u_name,String u_sex,
                               String u_date, String u_minzu,String u_area,
                               String u_country);