Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException
利用注解@Transaction解决Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query问题
·
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);
}
更多推荐
已为社区贡献1条内容
所有评论(0)