频繁操作出现的连接池无法获得大家帮忙分析下

zhyou110z 2010-11-19 08:20:15





org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object

	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)

	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

	at com.xinhe.db.DBpool.getConnection(DBpool.java:23)

	at com.xinhe.db.SubFileCategoryDAO.<init>(SubFileCategoryDAO.java:28)

	at com.xinhe.action.FileCategoryAction.<init>(FileCategoryAction.java:38)

	at sun.reflect.GeneratedConstructorAccessor27.newInstance(Unknown Source)

	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

	at java.lang.Class.newInstance0(Class.java:355)

	at java.lang.Class.newInstance(Class.java:308)

	at com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:123)

	at com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:154)

	at com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:143)

	at com.opensymphony.xwork2.ObjectFactory.buildAction(ObjectFactory.java:113)

	at com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:275)

	at com.opensymphony.xwork2.DefaultActionInvocation.init(DefaultActionInvocation.java:365)

	at com.opensymphony.xwork2.DefaultActionInvocation.access$000(DefaultActionInvocation.java:38)

	at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:83)

	at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)

	at com.opensymphony.xwork2.DefaultActionInvocation.<init>(DefaultActionInvocation.java:74)

	at com.opensymphony.xwork2.DefaultActionProxy.prepare(DefaultActionProxy.java:189)

	at org.apache.struts2.impl.StrutsActionProxyFactory.createActionProxy(StrutsActionProxyFactory.java:41)

	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:494)

	at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:422)

	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:191)

	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:286)

	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)

	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

	at java.lang.Thread.run(Thread.java:619)

Caused by: java.util.NoSuchElementException: Timeout waiting for idle object

	at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958)

	at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)

	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)

	... 35 more

快速频繁的操作系统出现上面的异常

我数据源配置如下用的是TOMCAT6.0



<Resource name="jdbc/DBpool"   

  auth="Container"

  type="javax.sql.DataSource"  

  username="root"				

  password="root"				

  maxIdle="50"					

  maxAction="100"				

  maxWait="5000"				

  driverClassName="com.mysql.jdbc.Driver" 

  removeAbandoned="true"   

  removeAbandonedTimeout="30"

  url="jdbc:mysql://localhost:3306/oasystem?useUnicode=true&characterEncoding=UTF-8"/>