javax.persistence.TransactionRequiredException: Executing an update/delete query

牧歌ing

于 2021-09-10 11:41:23 发布

阅读量639

点赞数

分类专栏： Java Errors 文章标签： hibernate java spring

本文链接：https://blog.csdn.net/u013010499/article/details/120218725

版权

Java Errors 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

javax.persistence.TransactionRequiredException: Executing an update/delete query
	at org.hibernate.internal.AbstractSharedSessionContract.checkTransactionNeededForUpdateOperation(AbstractSharedSessionContract.java:409)
	at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1601)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:409)
	at com.sun.proxy.$Proxy243.executeUpdate(Unknown Source)
	at bynear.web.service.RequirementInsertService.replyOldToNewSite(RequirementInsertService.java:417)
	at bynear.web.service.RequirementInsertService.ss(RequirementInsertService.java:509)
	at bynear.web.service.RequirementInsertService$$FastClassBySpringCGLIB$$ff41465b.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)

public class RequirementInsertService{

	@Autowired
    DemandOutService demandOutService;

    @Transactional
    @Modifying
	public void replyOldToNewSite(){
		String ss="INSERT INTO demandout ...."
		//需要用这种才不会报错
		demandOutService.insertDemandout(insertsql);

		//如果执行下面这段会报错
        //entityManager.createNativeQuery(insertsql).executeUpdate();//执行插入语句
	}
}

public class DemandOutService{
    @Transactional
    @Modifying
	public void insertDemandout(){
        entityManager.createNativeQuery(insertsql).executeUpdate();//执行插入语句
	}
}