手工事务提交结束后，数据全部入库了后报错

最新推荐文章于 2022-12-13 15:51:43 发布
最新推荐文章于 2022-12-13 15:51:43 发布
阅读量381 收藏
点赞数 1
分类专栏： 数据库 java EE
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/klx502/article/details/85234740
版权

 

手工事务结束后，切面事务再次提交，导致报错？？

public int saveMores(){
    final DefaultTransactionDefinition def = new DefaultTransactionDefinition();
    def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRES_NEW);//开启新事务
    final TransactionStatus st = transactionManager.getTransaction(def);
    try{
        for(遍历){
            //100条数据
        }
        transactionManager.commit(st);// 提交事务
    }catch(e){
        transactionManager.commit(st);// 补提交事务
    }
}


org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,806,351 milliseconds ago.  The last packet sent successfully to the server was 1,806,878 milliseconds ago.
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:332)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:532)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.uniform.user.service.local.sale.SaleService$$EnhancerBySpringCGLIB$$167da9fc.syncEmptySidUser(<generated>)
	at com.uniform.user.controller.ResourceController.createSidIsNull(ResourceController.java:1008)
	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.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:866)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1104)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1520)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1476)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,806,351 milliseconds ago.  The last packet sent successfully to the server was 1,806,878 milliseconds ago.
	at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:172)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
	at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:834)
	at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:334)
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:211)
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:329)
	... 55 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 1,806,351 milliseconds ago.  The last packet sent successfully to the server was 1,806,878 milliseconds ago.
	at sun.reflect.GeneratedConstructorAccessor100.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:59)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:103)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
	at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:593)
	at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:656)
	at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:966)
	at com.mysql.cj.protocol.a.NativeProtocol.sendQueryString(NativeProtocol.java:912)
	at com.mysql.cj.NativeSession.execSQL(NativeSession.java:1162)
	at com.mysql.cj.jdbc.ConnectionImpl.commit(ConnectionImpl.java:822)
	... 58 more
Caused by: java.net.SocketException: Connection reset
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:115)
	at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
	at com.mysql.cj.protocol.a.SimplePacketSender.send(SimplePacketSender.java:55)
	at com.mysql.cj.protocol.a.TimeTrackingPacketSender.send(TimeTrackingPacketSender.java:49)
	at com.mysql.cj.protocol.a.NativeProtocol.send(NativeProtocol.java:584)
	... 63 more

 

 

希望有大牛路过指出原因？ 

 

kong的编程历程
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
Ajax 提交表单数据到入库的全盘操作流程分享
10-26
以下是Ajax 提交表单数据到入库的全盘操作流程，希望本文对广大php开发者有所帮助，感谢阅读本
Sharding-JDBC 事务提交异常(Druid空闲检测未剔除已失效连接)
寒武没有纪
11-15 2473
异常问题 最近线上环境有一个服务频繁出现更新异常，提示不能提交JDBC事务，但是事务并没有回滚。 org.springframework.transaction.TransactionSystemException：Could not commit JDBC transaction; nested exception is java.sql.SQLException 完整报错信息： com.XXX.XXXX.XX.XXXXXX.facade.RuleUpdateFacadeService.updateP
分布式事务提交失败
wyn20101342的博客
06-10 2556
io.seata.common.exception.FrameworkException: No available service
Spring源码深度解析：二十一、事务实现⑤ - 事务的提交
代码的知行者
12-13 753
如果事务被设置了回滚标识，则不会提交,直接回滚如果事务中有保存点信息则不会提交事务操作。如果事务非新事务的时候也不会去执行提交事务操作。
Spring中使用DataSourceTransactionManager手动提交或回滚事务
yxhxj2006的专栏
03-21 1万+
      在使用spring进行web开发时，虽然spring提供的注解方式可以方便的处理很多原来需要手动提交或回滚的事务，但是注解方式有自己使用的局限，比如在类的内部调用方法时，注解方式处理的事务就无法被触发，此时可能需要手动处理相关数据库的事务。本文记录在spring开发时使用Spring提供的DataSourceTransactionManager进行事务提交或回滚处理。主要步骤如下：1、...
【Seata】AT模式常见报错及解决
柒杯红酒
11-14 5477
seata 、RmTransactionException:Runtime、ShouldNeverHappenException、RmTransactionException:Response
海量影像数据集入库策略.docx
12-18
海量影像数据集入库策略.docx
cad地形的数据入库处理技术共.pdf
04-10
cad地形的数据入库处理技术共.pdfcad地形的数据入库处理技术共.pdfcad地形的数据入库处理技术共.pdfcad地形的数据入库处理技术共.pdfcad地形的数据入库处理技术共.pdfcad地形的数据入库处理技术共.pdf
规划方案成果数据入库作业流程.docx
12-14
规划方案成果数据入库作业流程.docx
Spring2.0 DataSourceTransactionManager 事务回滚问题
frank_cn
04-10 1835
在使用Spring的DataSourceTransactionManager过程中，系统发生第一次错误并进行回滚，可是已经提交的数据没有回滚，从第二次开始，系统发生错误后回滚就正常了。 [code] //对Spring的事务简单封装，使用DataSourceUtil获得和释放链接。 TransactionManager manager = new TransactionManager ();...
事务管理器的具体实现DataSourceTransactionManager
yangzsirr的博客
11-13 2037
前文我们讨论了抽象的TransactionManager实现AbstractPlatformTransactionManager，其定义诸多模板方法，主要目的是处理事务的传播行为，在合适的时机挂起当前事务，本事务完成后重放挂起的事务，参见AbstractPlatformTransactionManager解析，而DataSourceTransactionManager作为抽象类的具体实现，就是实现了对与DB数据源如何创建事务，提交事务等等，也就是对抽象类中抽象方法的实现。 doGetTra...
Mysql异常刨析：Could not commit JDBC transaction;No operations allowed after statement closed
热门推荐
FeelTouch Labs
05-27 1万+
问题描述异常堆栈如下：org.springframework.transaction.TransactionSystemException: nested exception is com.mysql.jdbc.excedbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed...
Spring 随笔 transactional 6-事务提交
hyoka的博客
10-03 540
Spring 随笔 transactional 6-事务提交
腾讯TDSQL线上问题排查记录
破风
05-26 899
项目采用腾讯TSF框架，数据库为TDSQL，在执行数据保存时，报错如下： "Could not commit JDBC transaction; nested exception is java.sql.SQLException: Got an error in state of 'preparing', transaction aborted, xid='4-46-9303eaf-60ada4a8-2a', errmsg='You have an error in your SQL syntax; c
事务结束发生错误，错误信息：Could not commit JDBC transaction； nested exception is java.sql.SQLException: Connecti
qq_39201012的博客
12-29 1万+
事务结束发生错误，错误信息：Could not commit JDBC transaction; nested exception is java.sql.SQLException: Connection com.mysql.jdbc.JDBC4Connection@66fcd8bf is closed.事务结束发生错误，错误信息：Could not commit JDBC transaction; nested exception is java.sql.SQLException: Connection
基于was的SSH框架频繁出现java.sql.SQLException: Closed Connection
zhangyaoyaoai的专栏
11-17 507
系统环境： linux + WAS + SSH 频繁出现以下错误： org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException: Closed Connection Caus...
tidb写写冲突
xuliqi98的博客
08-05 549
tidb写写冲突
Caused by: org.hibernate.TransactionException: JDBC commit failed
weixin_43692760的博客
04-22 2954
一、问题：redhat7环境下部署tomcat服务器，启动2、3天就会报如下错误： 严重: Servlet.service() for servlet action threw exception org.springframework.transaction.TransactionSystemException: Could not commit Hibernate transaction; n...
org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction
weixin_43526092的博客
07-29 6056
[11:48:17:331] [ERROR] - cn.wkgb.common.exception.DefaultExceptionHandler.conversionErrorHandler(DefaultExceptionHandler.java:31) - 参数异常捕获 org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is jav
pycharm安装第三方库后，调用还是报错
最新发布
04-28
在Python代码中，你需要使用import语句来导入库，如果你的导入语句有误，也会导致报错。 如果以上步骤都没有解决问题，你可以尝试在PyCharm中重新安装第三方库或者尝试使用其他Python IDE来进行调试。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值