200分求Pool not open异常解决办法

[Rick_ang]

msg: java.lang.IllegalStateException: Pool not open
StackTrace:
org.apache.commons.pool.BaseObjectPool.assertOpen(BaseObjectPool.java:123)
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:767)
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1560)
org.hibernate.loader.Loader.doQuery(Loader.java:661)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2144)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
org.hibernate.loader.Loader.list(Loader.java:2023)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
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$29.doInHibernate(HibernateTemplate.java:839)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:830)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:822)
com.gdnfha.atcs.datacollect.service.dao.hibernate.DataCollectHibernateDaoImpl.listWorkFlowItem(DataCollectHibernateDaoImpl.java:544)
com.gdnfha.atcs.datacollect.service.DataCollectServiceImpl.listWorkFlowItem(DataCollectServiceImpl.java:543)
sun.reflect.GeneratedMethodAccessor383.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
$Proxy11.listWorkFlowItem(Unknown Source)
com.gdnfha.atcs.datacollect.action.DataCollectAction.toNewBill(DataCollectAction.java:349)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216)
com.gdnfha.atcs.common.BaseDispatchAction.execute(BaseDispatchAction.java:91)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
com.gdnfha.atcs.web.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:91)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
java.lang.Thread.run(Unknown Source)

GOOGLE了一下，发现好像是Spring与Hibernate最大连接数的问题，请问要如何优化配置呢，现在只能默认为10个连接，如何解决？

[zqpsswh]

把最大并发数改大就行

[Rick_ang]

具体是改哪里呢？改spring配置文件的dataSource么，我加了maxActive这样可以么

[jicken_woo]

在哪配置的在哪改!

[Rick_ang]

YuLimin(阿敏总司令：简单就是美—钻石闪闪您快结贴！) ( ) 信誉：776 Blog 加为好友 2007-5-13 9:39:11 得分: 0



不要用commons.pool，用C3P0



----------------------------------
可以讲的详细点么？跟Spring和Hibernate怎么集成？跟以前一样？？

[YuLimin]

不要用commons.pool，用C3P0

[For_suzhen]

先从http://sourceforge.net/projects/c3p0/下载最新的C3P0连接池,将lib下的两个jar文件,连同数据库的JDBC驱动一起复制到tomcat/common/lib文件夹下

[For_suzhen]

然后再配置，估计都一样的
只是个第三方库吧

[For_suzhen]

http://powerlyj.blogchina.com/powerlyj/1831156.html

[demonxin]

解决了没？我也出现同样的问题。。。