总是提示MYSQL数据库无法连接（非八小时自动断开问题）

Question

用JAVA开发的网站，数据库为MYSQL，在本机和自动的服务器上运行均没有问题，但是放在虚拟空间里之后，刚开始好像是八小时自动断开数据库的问题，也没太在意，但这两天总是重启了Tomcat之后，不到五分钟就找不开网站了，提示如下：type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: could not execute query; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute query
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:286)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.crbt123.common.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:21)
root cause org.springframework.dao.DataAccessResourceFailureException: could not execute query; nested exception is org.hibernate.exception.JDBCConnectionException: could not execute query
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:612)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
com.crbt123.dao.hibernate.UserInfoDaoHibernate.isexistuserinfo(UserInfoDaoHibernate.java:139)
com.crbt123.service.impl.UserInfoManagerImpl.isexistuserinfo(UserInfoManagerImpl.java:52)
com.crbt123.web.action.IndexAction.execute(IndexAction.java:80)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.crbt123.common.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:21)
root cause org.hibernate.exception.JDBCConnectionException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.loader.Loader.doList(Loader.java:2223)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
org.hibernate.loader.Loader.list(Loader.java:2099)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.springframework.orm.hibernate3.HibernateTemplate$30.doInHibernate(HibernateTemplate.java:926)
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:917)
com.crbt123.dao.hibernate.UserInfoDaoHibernate.isexistuserinfo(UserInfoDaoHibernate.java:139)
com.crbt123.service.impl.UserInfoManagerImpl.isexistuserinfo(UserInfoManagerImpl.java:52)
com.crbt123.web.action.IndexAction.execute(IndexAction.java:80)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:110)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
com.crbt123.common.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:21)
root cause com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed due to underlying exception/error:
** BEGIN NESTED EXCEPTION ** 请问各位这是什么原因？有什么解决办法没有？谢谢

Answer 1

不是写的很明显
org.hibernate.exception.JDBCConnectionException: could not execute query 
jdbc连接内部异常

Answer 2

加大Mysql连接数
http://hi.baidu.com/candy%D0%A1%C6%F0/blog/item/438da772d2d083148701b00a.html

Answer 3

确定程序是没问题的，传到虚拟主机上之后才出现的问题，现在重启tomcat也不起作用了，只要过个一两分钟，网站就打不开了，是需要配置hibernate.cfg.xml文件吗？

Answer 4

连接数小吧 
打开的连接没有及时关闭 
在hibernate.cfg.xml中，在url的连接后加上autoReconnect=true

Answer 5

用的是虚拟主机，无法修改MY.ini文件

Answer 6

hibernate.cfg.xml文件里配置jdbc时能指定连接数大小不？