程序访问数据库时出现不能连接的问题
?每天第一次访问mysql数据库时都会出现下面这样的问题，每天凌晨我都用mysqldump做了数据库的备份，不知道是不是这个引起的，该怎么办呢？HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Cannot close connectionorg.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)javax.servlet.http.HttpServlet.service(HttpServlet.java:709)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)com.kt.ecard.jolly.util.LoginValidateFilter.doFilter(LoginValidateFilter.java:64)com.kt.ecard.wuyf.util.filter.CharacterFilter.doFilter(CharacterFilter.java:73)
?
root cause
org.hibernate.exception.GenericJDBCException: Cannot close connectionorg.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:91)org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:79)org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:347)org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:298)org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:187)org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:213)org.hibernate.jdbc.JDBCContext.connectionCleanedUp(JDBCContext.java:100)org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:286)org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:218)org.hibernate.impl.SessionImpl.close(SessionImpl.java:317)com.kt.ecard.jolly.dao.utils.HiberManager.closeSession(HiberManager.java:66)com.kt.ecard.jolly.util.biz.BusinessHandle.invoke(BusinessHandle.java:134)$Proxy0.logon(Unknown Source)com.kt.ecard.wuyf.usermanagement.action.UserAction.logon(UserAction.java:125)sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)java.lang.reflect.Method.invoke(Method.java:585)org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:171)org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)javax.servlet.http.HttpServlet.service(HttpServlet.java:709)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)com.kt.ecard.jolly.util.LoginValidateFilter.doFilter(LoginValidateFilter.java:64)com.kt.ecard.wuyf.util.filter.CharacterFilter.doFilter(CharacterFilter.java:73)
?
root cause
java.sql.SQLException: Already closed.org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84)org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)org.hibernate.connection.DatasourceConnectionProvider.closeConnection(DatasourceConnectionProvider.java:74)org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:343)org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:298)org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:187)org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:213)org.hibernate.jdbc.JDBCContext.connectionCleanedUp(JDBCContext.java:100)org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:286)org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:218)org.hibernate.impl.SessionImpl.close(SessionImpl.java:317)com.kt.ecard.jolly.dao.utils.HiberManager.closeSession(HiberManager.java:66)com.kt.ecard.jolly.util.biz.BusinessHandle.invoke(BusinessHandle.java:134)$Proxy0.logon(Unknown Source)com.kt.ecard.wuyf.usermanagement.action.UserAction.logon(UserAction.java:125)sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)java.lang.reflect.Method.invoke(Method.java:585)org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)org.apache.struts.actions.MappingDispatchAction.execute(MappingDispatchAction.java:171)org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415)javax.servlet.http.HttpServlet.service(HttpServlet.java:709)javax.servlet.http.HttpServlet.service(HttpServlet.java:802)com.kt.ecard.jolly.util.LoginValidateFilter.doFilter(LoginValidateFilter.java:64)com.kt.ecard.wuyf.util.filter.CharacterFilter.doFilter(CharacterFilter.java:73)
?
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.
Apache Tomcat/5.5.27