jpa批量删除数据_使用JPA EntityManager删除批处理中的行

最新推荐文章于 2022-01-14 20:43:41 发布
最新推荐文章于 2022-01-14 20:43:41 发布
阅读量643 收藏
点赞数
文章标签： jpa批量删除数据
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39609071/article/details/111495338
版权

I was trying to delete rows in a batch using JPA EntityManager. I got the following exception.

java.lang.IllegalStateException: Not allowed to create transaction on shared EntityManager - use Spring transactions or EJB CMT instead

at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:199)

at $Proxy783.getTransaction(Unknown Source)

at admin.dao.CountryDAO.delete(CountryDAO.java:109)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:64)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy786.delete(Unknown Source)

at admin.controller.CountryController.onSubmit(CountryController.java:166)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:601)

at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at filter.NoCacheFilter.doFilter(NoCacheFilter.java:30)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.channel.ChannelProcessingFilter.doFilter(ChannelProcessingFilter.java:144)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1822)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)

The method in my DAO that handles this multiple deletion is as follows.

@Override

@SuppressWarnings("unchecked")

@Transactional(readOnly=false, propagation=Propagation.REQUIRES_NEW)

public void delete(List list)

{

int i=0;

javax.persistence.EntityTransaction transaction = entityManager.getTransaction();

transaction.begin();

for(long id:list)

{

if(++i%49==0)

{

entityManager.flush();

}

entityManager.remove((Country)entityManager.find(Country.class, id));

}

transaction.commit();

}

I have tried to make it work just like a Hibernate transaction. I have gone through this blog which says something like,

"It is possible to perform batch writes using JPA, but it's highly dependent on the specific implementation of your persistence provider, database and JDBC driver."

According to the section - Optimization #8 - Batch Writing in that blog, I have set two properties in my persistence.xml file.

But it made no difference. I'm currently left only with writing a delete query replacing the code in the above method like,

entityManager.createQuery("delete from Country where countryId in(:id)").setParameter("id", list).executeUpdate();

So, is there any other way to execute batch using JPA EntityManager or should it be achieved by just using JPQL queries (which are in some cases, may not be appropriate)?

解决方案

You're using both declarative transactions (using @Transactional) and programmatic transactions. This makes no sense.

Spring starts, commits and rollbacks transactions for you, based on the @Transactional annotation. There's no need to start and commit transactions programmatically (and it's even a bug, as you just discovered).

Remove all your transactin handling code:

@Override

@SuppressWarnings("unchecked")

@Transactional(readOnly=false, propagation=Propagation.REQUIRES_NEW)

public void delete(List list) {

int i=0;

for(Long id : list) {

if(++i%49==0) {

entityManager.flush();

}

entityManager.remove((Country) entityManager.find(Country.class, id));

}

}

Also, you should use getReference() instead of find() to get a reference to the entity to delete. It would avoid lots of unnecessary select queries.

weixin_39609071
关注
jpa 删除是否成功_jpa delete无法删除 浅析JPA中EntityManager无法remove entity的问题 - 电脑故障 - 服务器之家...
weixin_33448981的博客
01-12 2268
jpa delete无法删除 浅析JPA中EntityManager无法remove entity的问题发布时间：2017-03-21来源：服务器之家JPA对于维护双边关系操作其实已经有明确说明，应该从parent一端来维护关系。今天遇到一个奇怪的事情，利用EntityManager.remove(entity)方法删除一个entity时，删不掉，也不报错。后来经过多方查证，解决了这个问题。ERD...
JPA EntityManager批量保存/删除
dream_heheda的博客
01-14 1464
实体类 import java.math.BigDecimal; import java.util.Date; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Index; import javax.persistence.Table; import lombok.Data; @Data
在Hibernate应用中处理批量更新和批量删除
09-01
在Hibernate应用中如何处理批量更新和批量删除
JPA与EntityManager批量新增、更改、删除
热门推荐
harveySOT
08-15 1万+
前言：采用JPA的saveAll进行批量新增时，速度会很慢，可以采用EntityManager进行批量操作。 1. 批量新增 使用EntityManager的persist(Object entity)方法： @Component public class ChannelBizImpl implements IChannelBiz { @PersistenceContext ...
mysql ef5 批量删除_EntityFramework：支持同一事务提交的批量删除数据实现思路
weixin_34779096的博客
01-27 231
一切从一段代码说起。。。下面一段代码是最近我在对一EF项目进行重构时发现的。protected override voidDoRemove(T entity){this.dbContext.Entry(entity).State =EntityState.Deleted;Committed= false;}protected override int DoRemove(System.Linq.Ex...
出现spring事务的异常：java.lang.IllegalStateException: Not allowed to create transaction on shared EntityMan
weixin_41082235的博客
07-01 7679
java.lang.IllegalStateException: Not allowed to create transaction on shared EntityManager - use Spring transactions or EJB CMT instead at org.springframework.orm.jpa.SharedEntityManagerCreator$Shared...
Spring Data JPA中文文档[1.4.3]_springdatajpa_erlang_waitxpf_
10-02
**Spring Data JPA** 是一个基于 **Java** 的开源框架，它是 **Spring Framework** 的一个模块，主要用于简化 **Java Persistence API (JPA)** 的使用。JPA 是 Java 平台上的一个标准，用于管理和持久化应用程序的...
使用SpringBoot-JPA进行自定义保存及批量保存功能
08-25
使用SpringBoot-JPA进行自定义保存及批量保存功能是指在Spring Boot应用程序中使用JPA（Java Persistence API）来实现自定义的保存和批量保存功能。JPA是一个Java API，它提供了一种对象关系映射（ORM）机制，允许...
07_传智播客JPA详解_使用JPA加载_更新_删除对象
03-24
总的来说，"07_传智播客JPA详解_使用JPA加载_更新_删除对象"这门课程将详细讲解如何利用JPA进行数据的存取操作，帮助开发者更好地理解和掌握JPA的精髓，提升数据库操作的效率和便捷性。通过学习，你将能够熟练地运用...
07_JPA详解_使用JPA加载_更新_删除对象.zip
05-06
Java Persistence API（JPA）是Java平台上的一个标准，用于管理关系数据库中的数据。它提供了一种面向对象的方式来处理数据库操作，使得开发人员可以使用Java对象来操作数据库记录，而无需编写大量的SQL代码。本教程...
怎么提交java源代码_java – 如何在@Transactional方法中手动强制提交？
weixin_36087357的博客
02-24 830
参见英文答案 >How to flush data into db inside active spring transaction?我使用Spring / Spring-data-JPA，发现自己需要在单元测试中手动强制提交。我的用例是，我正在进行一个多线程测试，其中我必须使用在线程生成之前持久化的数据。不幸的是，考虑到测试在@Transactional事务中运行，甚至是一个flush也不...
java entity 参照值_java – 使用entityManager.persist(Object)插入…值...
weixin_36207483的博客
03-06 501
public void miseAJourTranscoIdCroisiere(Integer idCroisiereKaravel, String idCroisiereArmateur, TypeArmateur typeArmateur) {IdCroisiereKaravelArmateur idRelationship = new IdCroisiereKaravelArmateur()...
JPA创建实体类映射表+ 创建索引
dream_heheda的博客
01-14 710
创建表tb_student + 创建索引 主键：studentId 索引： 联合索引: index_tb_student 单个索引: index_student_studentName 单个索引:index_student_studentAge import java.math.BigDecimal; import java.util.Date; import javax.persistence.Column; import javax.persistence.Entity; impor..
org.springframework.orm.jpa.JpaSystemException: ids for this class must be manually assigned before
大强博客
06-10 5350
错误信息： org.springframework.orm.jpa.JpaSystemException: ids for this class must be manually assigned before calling save(): com.xadhsd.dhframe.system.entity.SysUser; nested exception is org.hibernate.i...
Spring和SpringMVC父子容器注解扫描引发的javax.persistence.TransactionRequiredException异常问题
C.
07-31 559
做练习的时候出现了一个异常： javax.persistence.TransactionRequiredException: No EntityManager with actual transaction available for current thread - cannot reliably process 'remove' call org.spri...
探讨整合Spring前提下Jpa的EntityManager和Mybatis的SqlSession在不加@Transactional时会不会占用连接不释放（待完善）
yangxiaofei_java的博客
02-10 2073
探讨整合Spring前提下Jpa的EntityManager和Mybatis的SqlSession在不加@Transactional时会不会占用连接不释放（核心方法TransactionSynchronizationManager#isSynchronizationActive()用于判断是否开启事务）； EntityManager会主动释放连接， SqlSession不会主动释放连接， 但是Mapper动态代理类（引用了mybatis-spring.jar整合后产生的Mapper代理类中的SqlSessi
spring-data-jpa实现批量删除
qq_41894368的博客
02-21 5710
dao层： @Modifying @Transactional @Query("delete from Student s where s.id in (:ids) ") void deleteStudentById(@Param("ids") List<Integer> ids); 2. service层： @Transactional @Override...
如何使用jpa批量删除数据
最新发布
02-06
使用 JPA 批量删除数据的方法如下: 1. 使用 EntityManager 的 createQuery 方法创建一个 DELETE 查询。 2. 使用 setParameter 方法设置查询的参数。 3. 使用 executeUpdate 方法执行查询并返回受影响的行数。 例如...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值