关于 No operations allowed after connection closed.错误
来源:互联网 发布:js判断radio哪个被选中 编辑:程序博客网 时间:2024/05/16 19:17
ERROR - No operations allowed after connection closed.
2011-12-07 11:36:09 - ERROR - query failed
org.hibernate.exception.JDBCConnectionException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
分析,出现这种异常的原因是:
Mysql服务器默认的“wait_timeout”是8小时,也就是说一个connection空闲超过8个小时,Mysql将自动断开该connection。这就是问题的所在,在C3P0 pools中的connections如果空闲超过8小时,mysql将其断开,而C3P0并不知道该connection已经失效,如果这时有Client请求connection,C3P0将该失效的Connection提供给Client,将会造成上面的异常。
a)解决的方法有3种:
增加wait_timeout的时间。
减少Connection pools中connection的lifetime。
测试Connection pools中connection的有效性。
b)具体解决方案:
1、换一下JDBC驱动,JDBC3.1.0-alpha及以前版本会出现此问题,下载新的JDBC驱动
1、换一下JDBC驱动,JDBC3.1.0-alpha及以前版本会出现此问题,下载新的JDBC驱动
2、使用hibernate配置:
使用hibernate:
<property name="connection.autoReconnect">true</property> <!--这个是最主要的-->
<property name="connection.autoReconnectForPools">true</property>
<property name="connection.is-connection-validation-required">true</property>
加入以上property,可解决此问题,如果未使用hibernate等持久化管理框架,可在mysql的url中加入autoReconnect=true,这样就可以解决。
原因很简单。在对数据库操作结束后关闭连接是正确的做法,没什么大问题。至于出现:No operations allowed after connection closed。这样的问题原因只有一个,你这里和数据库的连接Connection是一个Static的,程序共享这一个Connection。所以第一次对数据库操作没问题,当把Connection关闭后,第二次还想操作数据库时Connection肯定不存在了。
0 0
- No operations allowed after connection closed 错误
- 关于 No operations allowed after connection closed.错误
- 关于 No operations allowed after connection closed.错误
- 关于 No operations allowed after connection closed问题
- solr no operations allowed after connection closed
- No operations allowed after connection closed
- Struts.......No operations allowed after connection closed.
- MySQLNonTransientConnectionException: No operations allowed after connection closed.
- No operations allowed after connection closed. 解决办法
- 问题:No operations allowed after connection closed.
- No operations allowed after connection closed
- No operations allowed after connection closed
- No operations allowed after connection closed异常的解决
- JDBC中No operations allowed after connection closed
- MyBatis连接MySQL出错:No operations allowed after connection closed
- 异常问题:No operations allowed after connection closed.
- MyBatis异常:No operations allowed after connection closed
- MySQL: No operations allowed after connection closed。解决办法
- x264中bs.h文件部分函数解读
- ubuntu 没有.ssh文件
- iOS Safari/WebKit对DeviceMotionEvent的实现
- 在线文档地址大全
- 多校第七场 1007 hdu 5375 Gray code(dp)
- 关于 No operations allowed after connection closed.错误
- 关于用创建vector<type> name类型的一维数组(vector<type> name[])来存储图(邻接表法储存)
- 详解C#break ,continue, return
- $.post 提交数据
- HDOJ 1301 Jungle Roads 最小生成树 kruskal && prim
- 28-反射机制-01-反射机制(概述&应用场景)
- 无线网
- CC2541 OSAL工作原理
- 28-反射机制-02-反射机制(细节&Class对象)