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

发布时间 2023-08-03 10:03:50作者: panyanquandexiaodi

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

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

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