Statement.executeQuery() cannot issue statements that do not produce result sets.

DeveloperHan / 2023-08-03 / 原文

在用Spring Boot JPA的时候导致Statement.executeQuery() cannot issue statements that do not produce result sets

解决方法:
@Query上加上@Modifying,表示不需要返回值

@Query对应到底层jdbc框架是Statement.executeQuery(),而@Modifying@Query对应的是Statement.execute();