项目里遇到的错误，望高手帮忙解决

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: org.hibernate.exception.GenericJDBCException: Cannot open connectionorg.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)org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)org.yidongn.filter.EncodingFilter.doFilter(EncodingFilter.java:22)

 

root cause

org.hibernate.exception.GenericJDBCException: Cannot open connectionorg.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)org.hibernate.loader.Loader.doQuery(Loader.java:673)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)org.hibernate.loader.Loader.doList(Loader.java:2220)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.yidongn.dao.impl.MarkerDAOImpl.queryAll(MarkerDAOImpl.java:25)org.yidongn.struts.action.TomkselectdAction.execute(TomkselectdAction.java:40)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)org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)org.yidongn.filter.EncodingFilter.doFilter(EncodingFilter.java:22)

 

root cause

org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle objectorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)org.hibernate.loader.Loader.doQuery(Loader.java:673)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)org.hibernate.loader.Loader.doList(Loader.java:2220)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.yidongn.dao.impl.MarkerDAOImpl.queryAll(MarkerDAOImpl.java:25)org.yidongn.struts.action.TomkselectdAction.execute(TomkselectdAction.java:40)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)org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)org.yidongn.filter.EncodingFilter.doFilter(EncodingFilter.java:22)

 

root cause

java.util.NoSuchElementException: Timeout waiting for idle objectorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)org.hibernate.loader.Loader.doQuery(Loader.java:673)org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)org.hibernate.loader.Loader.doList(Loader.java:2220)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.yidongn.dao.impl.MarkerDAOImpl.queryAll(MarkerDAOImpl.java:25)org.yidongn.struts.action.TomkselectdAction.execute(TomkselectdAction.java:40)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)org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)org.yidongn.filter.EncodingFilter.doFilter(EncodingFilter.java:22)