Spring hibernate mysql No operations allowed after statement closed

风月无伤 2014-03-23 02:35:37
sessionFactory spring中配置的sessionfactory代码 
<bean id="sessionFactory"

		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">

		<property name="dataSource" ref="dataSource" />

		<property name="packagesToScan">

			<list>

				<value>com.wds.registration.model</value>

				<value>com.jmy.essay.model</value>

				<value>com.jmy.picture.model</value>

			</list>

		</property>

		<property name="hibernateProperties">

			<props>

				<prop key="hibernate.dialect">

					org.hibernate.dialect.MySQLDialect

				</prop>

				<prop key="hibernate.show_sql">true</prop>

				<prop key="hibernate.hbm2ddl.auto">update</prop>

			</props>

		</property>

	</bean>

后台有个调用
	public class JEssayLogic {

	

	private SessionFactory sessionFactory;



	

	public E_ML find(E_ML e_ML) {

		

		Session session = sessionFactory.openSession();

		

				Query query = session.createQuery("SQL...................");

				

				List l = query.list();

				

		session.close();

		sessionFactory.close();

		return e_ML;

	}



	

	}
但是web程序连接长了 程序就会报
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:411)

	at com.mysql.jdbc.Util.getInstance(Util.java:386)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)

	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)

	at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:461)

	at com.mysql.jdbc.StatementImpl.getMaxRows(StatementImpl.java:2216)

	at org.apache.commons.dbcp.DelegatingStatement.getMaxRows(DelegatingStatement.java:237)

	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)

	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)

	at org.hibernate.loader.Loader.getResultSet(Loader.java:1967)

	at org.hibernate.loader.Loader.doQuery(Loader.java:802)

	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)

	at org.hibernate.loader.Loader.doList(Loader.java:2542)

	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)

	at org.hibernate.loader.Loader.list(Loader.java:2271)

	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)

	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)

	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)

	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)

	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)

	at com.jmy.logic.JEssayLogic.find(JEssayLogic.java:164)

	at com.jmy.service.impl.JEManagerImpl.find(JEManagerImpl.java:46)

	at com.jmy.action.JmyOnePage.loadPage(JmyOnePage.java:38)

	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:453)

	at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)

	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)

	at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:90)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)

	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:192)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)

	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)

	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)

	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510)

	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)

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

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

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

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

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

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

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

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

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

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

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

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

	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)

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

	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

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

	at java.lang.Thread.run(Thread.java:619)
这个错 goolge了一下 说是mysql断开一个长时没有响应的连接 我现在有个疑问 我已经把session都关闭了 再次访问的时候应该不存在长时间无响应 应该是重新创建session 为什么还会报上面的错
...全文
295 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
wyx100 2014-03-23
  • 打赏
  • 举报
 回复
引用 1 楼 coolbamboo2008 的回复:
还是用连接池吧，毕竟自己管理关闭有时候会忘掉
正解
coolbamboo2008 2014-03-23
  • 打赏
  • 举报
 回复
还是用连接池吧，毕竟自己管理关闭有时候会忘掉
mysql isclosed_报错：No operations allowed after statement closed
解决方法在调用存储过程的方法上添加事务注解解决过程我使用springboot2.0.5版本，采用其内置的数据库连接池HikariCP2.7.9，在调用存储过程时报错，该存储过程需要两个入参和一个出参。其中一条出错信息为：Caused by: org.hibernate.exception.GenericJDBCException: Unable to extract OUT/INOUT param...
Spring Boot环境下出现No operations allowed after connection close错误
一个基于springcloud的微服务项目，详细配置： SpringCloud + SpringMVC+SpringData JPA+ MySql+Postgresql其中项目配置了多数据源，前期开发测试是没什么问题的，但是等到项目在服务器上面测试时，第二天就上午出现了数据库连接异常。经过查看日志发现下面这个异常：注意异常信息： No operations allowed after connec...
今天项目报错： No operations allowed after connection closed
今天项目报错： No operations allowed after connection closed 错误原因：MySQL服务器默认的“wait_timeout”是28800秒即8小时，意味着如果一个连接的空闲时间超过8个小时，MySQL将自动断开该连接，而连接池却认为该连接还是有效的(因为并未校验连接的有效性)，当应用申请使用该连接时，就会导致上面的报错。最后定位到maybatis配置连接
关于springboot项目连接数据库No operations allowed after connection closed的解决
今天因为项目的需要在系统中配置了双数据源。但是在项目运行过程中，系统日志出现了No operations allowed after connection closed的错误。 错误原因是在更改了双数据源后，重写了datasource的config文件，application.yml只是简单配置了数据库地址和用户密码以及driver-class-name。 由于之前单数据源时并没有这个错误，所以可...
No operations allowed after connection closed
异常信息如下： org.springframework.dao.DataAccessResourceFailureException: could not prepare statement; nested exception is org.hibernate.exception.JDBCConnectionException: could not prepare statement at o
Web 开发

81,092

社区成员

341,718

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章