Executing an update/delete query； nested exception is javax.persistence.TransactionRequiredException

原创已于 2022-07-18 19:05:12 修改 · 7.5k 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#java #spring #spring boot

于 2022-07-18 18:57:19 首次发布

JPA 专栏收录该内容

1 篇文章

订阅专栏

本文探讨了在使用Spring JPA进行自定义INSERT查询时遇到的TransactionRequiredException，重点在于如何通过添加@Transactional注解来解决此问题，包括区分Spring和JTA的Transaction注解。

Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query

在用Spring JPA的时候，用到了@Query注解，在自定义INSERT语句的时候出现了问题：

public interface ApplicationRepository extends JpaRepository<Application, BigInteger> {
    @Modifying
    @Query(value = "INSERT INTO report(aaa,bbb) VALUES " +
            " (?1, ?2)",nativeQuery = true)
    void InsertDataIntoReport(String s1,String s2);
}

报错：Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query。

解决方案就是在该接口前加上另一个注解**@Transaction**
！！！@Transaction必须是org.springframework.transaction.annotation.Transactional,
而非javax.transaction.Transactional.

import org.springframework.transaction.annotation.Transactional;

@Transaction
public interface ApplicationRepository extends JpaRepository<Application, BigInteger> {
    @Modifying
    @Query(value = "INSERT INTO report(aaa,bbb) VALUES " +
            " (?1, ?2)",nativeQuery = true)
    void InsertDataIntoReport(String s1,String s2);
}