java jpa更新数据,使用JPA和Java更新查询

我正在尝试更新我的JPA存储库

@Transactional

public interface UserRepository extends JpaRepository {

User findByUsername(String username);

User findById(Long id);

@Query(value = "update user t set t.rule_id = NULL where t.rule_id = :id", nativeQuery = true)

List setNUll(@Param("id") String id);}

这是我的控制器的一部分：

@RequestMapping(value = "/admin/rule/{id}/edit", method = RequestMethod.GET)

public String editRule(@PathVariable Integer id, Model model)

{

userService.setNUll(Integer.toString(id));

model.addAttribute("rule", ruleCrudService.getRuleById(id));

updateUserData();

return "ruleForm";

}

并且此错误在我的浏览器中出现：

There was an unexpected error (type=Internal Server Error, status=500).

could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

服务器还说：

SQL Error: 0, SQLState: S1009

2017-06-18 12:51:15.778 ERROR 10388 — [nio-8080-exec-4] o.h.engine.jdbc.spi.SqlExceptionHelper : Can not issue data manipulation statements with executeQuery().

2017-06-18 12:51:15.844 ERROR 10388 — [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[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：无法使用executeQuery()发出数据操作语句.