spring data jpa @Query注解中delete语句报错
项目中需要删除掉表中的一些数据
@Query("delete from EngineerServices es where es.engineerId = ?1")
int deleteByEgId(String engineerId);
但是提示了错误
org.hibernate.hql.QueryExecutionRequestException: Not supported for DML operations
通过查阅相关的资料发现,对于执行update和delete语句需要添加@Modifying注解
@Modifying
@Query("delete from EngineerServices es where es.engineerId = ?1")
int deleteByEgId(String engineerId);
不过,添加之后运行又出现了另一个错误
nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query
发现缺少Transaction,于是添加@Transactional
@Modifying
@Transactional
@Query("delete from EngineerServices es where es.engineerId = ?1")
int deleteByEgId(String engineerId);
到此,这条delete语句终于可以成功的执行了。
我是个双鱼座的小王子,沉浸在自己的代码世界里,去探索这未知的世界,希望遇到更多的小伙伴一起前行!