当前位置: 代码迷 >> Java Web开发 >> org.springframework.transaction.CannotCreateTransactionException:
  详细解决方案

org.springframework.transaction.CannotCreateTransactionException:

热度:665   发布时间:2016-04-17 01:14:55.0
服务器 mysql数据库异常
数据库用的是mysql,后台用的是hibernate,在tomcat中配置连接池,服务器中经常报一些如下的错误:
Java code
2009-02-06 08:22:20,588 INFO [cn.legend.myznt.util.SystemExceptionHandler] - 出现异常org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin failed: Caused by: org.hibernate.TransactionException: JDBC begin failed:     at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:68)    at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1290)    at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:510)    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)    at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:629)    at cn.qdrk.strive.dao.hibernate.UserDaoHibernate$$EnhancerByCGLIB$$10afb0ec.queryAccount(<generated>)    at cn.qdrk.strive.struts.action.LoginAction.execute(LoginAction.java:44)    at org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)    at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)    at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)    at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)    at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)    at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)    at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)    at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)    at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)    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:175)    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)    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:263)    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)    at java.lang.Thread.run(Unknown Source)Caused by: com.mysql.jdbc.CommunicationsException: Communications link failureLast packet sent to the server was 120 ms ago.    at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2985)    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2871)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3414)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)    at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4874)    at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)    at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)    at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:63)    ... 41 moreCaused by: java.net.SocketException: Software caused connection abort: recv failed    at java.net.SocketInputStream.socketRead0(Native Method)    at java.net.SocketInputStream.read(Unknown Source)    at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113)    at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)    at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)    at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2428)    at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2882)    ... 50 more
  相关解决方案