mysql报错：No operations allowed after statement closed.

最新推荐文章于 2024-02-18 17:25:36 发布
最新推荐文章于 2024-02-18 17:25:36 发布
阅读量368 收藏
点赞数
文章标签： java 数据库
原文链接：http://www.cnblogs.com/daisyleamo/p/3148703.html
版权 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:985)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
	at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:381)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1775)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1888)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	at com.nova.dao.impl.UserDaoImpl.countUser(UserDaoImpl.java:440)
	at com.nova.service.impl.UserServiceImpl.getAllUserPageList(UserServiceImpl.java:174)
	at com.nova.action.UserAction.getAllUserPageList(UserAction.java:40)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404)
	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:267)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)
	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:48)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:184)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:83)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:207)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:74)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:127)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:107)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:115)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:143)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:121)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:170)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:123)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
	at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:504)
	at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:422)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:619)

　　其实看错误这么长，还是会被吓到的。。。。

　　原因很简单：这里和数据库的连接Connection是一个Static的，程序共享这一个Connection。所以第一次对数据库操作没问题，当把Connection关闭后，第二次还想操作数据库时Connection肯定不存在了。

转载于:https://www.cnblogs.com/daisyleamo/p/3148703.html

weixin_30920597
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql isclosed_报错：No operations allowed after statement closed
weixin_34656273的博客
02-07 2019
解决方法在调用存储过程的方法上添加事务注解解决过程我使用springboot2.0.5版本，采用其内置的数据库连接池HikariCP2.7.9，在调用存储过程时报错，该存储过程需要两个入参和一个出参。其中一条出错信息为：Caused by: org.hibernate.exception.GenericJDBCException: Unable to extract OUT/INOUT param...
cp30报错No operations allowed after connection closed
01-08
使用mysql+cp30连接池时，报错No operations allowed after connection closed。从报错信息来看，是connection断开导致的错误。在网上搜索后发现，较新版本的mysql配置了connection的默认时间，默认时间一般为8个...
No operations allowed after statement closed.
10-18
解决：com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
java.sql.SQLException: No operations allowed after statement closed.
最新发布
我的博客
02-18 886
java.sql.SQLException: No operations allowed after statement closed.是什么原因导致的？MySQL的waiting for handler commit又是怎么导致的？
MYSQL 异常：No operations allowed after statemente closed
qq_38122518的博客
12-03 5163
关于这个异常，我今天遇到的情况是：小量数据执行时完全没有问题，当执行大批量数据时就会报这个错误，并且回滚操作也报错了。 项目原因分析： sql执行效率比较低，大数据量时，导致数据库连接超时，释放了连接，导致该执行无法进行任何数据库交互，包括回滚提交等。 解决方案：第一种：找到所使用连接池连接超时时间控制的参数，然后延长 第二种：优化sql执行速度，保证在连...
com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed.
jinchunzhao的博客
03-04 6102
一、错误信息 Caused by: com.mysql.cj.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Na..
Mysql异常No operations allowed after statement closed
ggk911的博客
01-02 3564
Mysql异常No operations allowed after statement closed
MYSQL拒绝访问报错not allowed to connect
12-15
message from server: “Host ‘****’ is not allowed to connect to this MySQL server 1:在登录mysql服务器 2:执行：GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ WITH GRANT OPTION //赋予任何主机访问数据的...
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
基于Springboot2.3访问本地路径下静态资源的方法(解决报错：Not allowed to load local resource)
08-18
主要介绍了基于Springboot2.3访问本地路径下静态资源的方法(解决报错：Not allowed to load local resource)，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着...
Mysql连接问题
song_quan_的博客
05-17 760
连接MySQL长时间不连接后报错`com.mysql.cj.core.exceptions.ConnectionIsClosedException: No operations allowed after connection closed.`的解决办法 报错：com.mysql.cj.core.exceptions.ConnectionIsClosedException: No operations allowed after connection closed. 添加&autoRe.
mysql isclosed_Mysql 连接问题：No operations allowed after connection closed.
weixin_30910583的博客
01-20 749
使用阿里云上的mysql数据库，就出现这个问题了，之前在本地没有出现过。网上说要修改连接池的配置，不过 content-center 、user-center中都没有使用连接池呀请问大目老师，应该怎么设置？10:15:44.052 ERROR 8883 --- [nio-8020-exec-8] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet....
java.sql.SQLException: No operations allowed after connection closed.Connection was implicitly close...
abc419687686的博客
02-18 1137
Google 这个错误，发现也有好多人和我一样，遇到这个问题，参考他们的解决方案，就是在c3p0里加入测试连接的参数， 于是我也写了个保持连接的线程，在server启动的时候就执行，但是，试验之后，问题依旧。 后来经过思考，发现错误的原因是：在程序中，有一个数据库连接，是长期保存的，但是因为对方是在线服务器，所以估计设置了对于长sql连接，会有一个timeout，然后主动断开连...
ActiveMQ java.sql.SQLException: No operations allowed after statement closed.
09-01 639
ActiveMQ java.sql.SQLException: No operations allowed after statement closed. 文章原作者地址：https://www.cnblogs.com/zhengyun_ustc/archive/2012/11/10/activemq_inactivity.html 环境：mysql5.5 activemq5.15 mysql主从同步，然后日志里面有报错 java.sql.SQLException: No operations allowe
java.sql.SQLException: No operations allowed after
天青色等烟雨 而我在等你
10-22 828
情况是这样的，我使用tomcat5.0.28+hibernate2+mysql4，在M$的系统下没出现过任何问题，但将系统装到linux上以后（redhat9及as3），发现过一段时间后就没有办法连接上数据库，查看日志，内容如下： ERROR http-8080-Processor22 net.sf.hibernate.util.JDBCExceptionReporter - Could not ...
问题：No operations allowed after statement closed.
mybabytao的博客
10-31 2769
网上查，是wait_timeout的设置导致服务端连接关闭，wait_timeout mysql默认是8小时，这个如果不改动是不会变的，也就是说一个connection空闲超过8个小时，Mysql将自动断开该connection，与mysql服务器对应的，应用使用druid连接池，也有这个配置，那么连接池的这个配置不能出现>mysql的这个值，如果大于那肯定会存在一个异常保错。根本原因：报这个错，是数据库连接在服务端被关闭了，但是事务并没有执行完成导致的，这个是根本原因，这个根本原因没有问题，
SQLException:no opration allowed after statement closed问题排查
weixin_43589025的博客
03-20 1万+
SQLException:no opration allowed after statement closed问题排查 文章目录SQLException:no opration allowed after statement closed问题排查问题深入Druid探索原由概念介绍大体流程:PS初始化和close过程prepareStatement()：初始化PScloseStatement()：关闭Statement根据代码与实践总结druid 1.0.29中是如何修复的？总结 问题 前几天，我负责的一个应
MySQL出现MySQLNonTransientConnectionException: No operations allowed after statement closed异常的解决办法
weixin_38043409的博客
09-18 1352
出现异常的原因： Mysql在5以后针对超长时间DB连接做了一个处理，Mysql服务器默认的“wait_timeout”是8小时，也就是说一个connection空闲超过8个小时，Mysql将自动断开该connection。所以使用连接池的时候虽然连接对象还在但是链接数据库的时候会一直报这个异常。 解决办法： 进入MySQL查看设置的时间，show global variables like ‘wait_timeout’; 1、增加MySQL的 wait_timeout 的时间 windows环境下,修改m
解决 No operations allowed after statement closed || marked as broken because of SQLSTATE(08003)
热门推荐
LaiLaiPengPeng的博客
04-26 1万+
解决：Cause: java.sql.SQLException: No operations allowed after statement closed. 因这个问题调试了一下午的debug，希望能给大家帮助。 最开始以为是 IOC 连接关闭问题，开启子线程问题之类的。 NO ,NO,NO 其实此处是线程池连接生命周期的问题。 ELK 都已经提示了我，因经验不足，写出来大家一起交流。总比一个人调试debug到????为止吧，欢迎留言交流，因为更细节的东西我无法解释，求大神告知，解决了却不知道为啥，也着实
MySQL为什么报错No operations allowed after statement closed.
10-27
MySQL报错"No operations allowed after statement closed."通常是由于在已经关闭的语句上执行了操作。这可能是因为在语句执行完成后，未正确关闭语句或者在语句关闭之后仍然尝试执行操作。为了解决这个问题，可以...

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值