@Modifying注解与Can not issue data manipulation statements with executeQuery().

阿圣同学

于 2021-09-10 18:11:01 发布

阅读量184

点赞数

CC 4.0 BY-SA版权

分类专栏： SpringBoot bug处理文章标签： java mysql hibernate

本文链接：https://blog.youkuaiyun.com/weixin_46223196/article/details/120227413

bug处理同时被 2 个专栏收录

23 篇文章

订阅专栏

SpringBoot

20 篇文章

订阅专栏

本文记录了在使用Spring Data JPA时遇到的更新和删除操作错误，详细描述了从报错信息到问题解决的整个过程。首先，尝试使用@Query进行更新操作导致SQL错误，接着添加@Modifying注解后出现事务错误，最终通过添加@Transactional解决了问题。总结得出，在JPA中执行修改和删除操作需同时使用@Modifying和@Transactional注解。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我是在使用Spring Data jpa中遇到这个问题的
具体报错如下

#[admin-DESKTOP-7MF0MCO.log]# 2021-09-10 18:01:49 WARN [http-nio-8080-exec-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: S1009
#[admin-DESKTOP-7MF0MCO.log]# 2021-09-10 18:01:49 ERROR [http-nio-8080-exec-3] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Can not issue data manipulation statements with executeQuery().
#[admin-DESKTOP-7MF0MCO.log]# 2021-09-10 18:01:49 ERROR [http-nio-8080-exec-3] org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/].[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet] with root cause
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.22.jar:8.0.22]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.22.jar:8.0.22]

我的代码如下
业务层实现类

@Override
    public ResponseResult<String> delete(Long id){
        transRepository.updateByTransId(id);
        return new ResponseResult<String>().setSuccessData(null);
    }

持久层

@Query(nativeQuery = true, value = " update imp_config_trans set status = '0' , del_flag = '1' where id = ?")
void updateByTransId(Long id);

经过百度，发现，@Query已经不能适用于修改、删除操作了，
于是我加入了@Modifying，如下

@Modifying
@Query(nativeQuery = true, value = " update imp_config_trans set status = '0' , del_flag = '1' where id = ?")
void updateByTransId(Long id);

结果报事务错，

javax.persistence.TransactionRequiredException: 
Executing an update/delete query

于是加入@Transactional注解

@Modifying
@Transactional
@Query(nativeQuery = true, value = " update imp_config_trans set status = '0' , del_flag = '1' where id = ?")
void updateByTransId(Long id);