A ResourcePool could not acquire a resource from its primary factory or source.

Hi,

The problem appeared only after a while of using the application. This most probably is caused by hibernate cfg configuration but i have no idea on how to solve this.

The below are the stack trace. Please help. Thanks.

2009-07-30 08:36:19 StandardWrapperValve[action]: Servlet.service() for servlet action threw exception
org.hibernate.exception.GenericJDBCException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:301)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:110)
	at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
	at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1426)
	at org.hibernate.loader.Loader.doQuery(Loader.java:637)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:221)
	at org.hibernate.loader.Loader.doList(Loader.java:1858)
	at org.hibernate.loader.Loader.list(Loader.java:1842)
	at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1329)
	at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
	at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:433)
	at com.mymcsb.ewms.entity.Company.findByName(Company.java:111)
	at com.mymcsb.core.security.LoginAction.execute(LoginAction.java:68)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
	at com.mymcsb.base.ActionServlet.process(ActionServlet.java:41)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at com.mymcsb.core.security.SecurityFilter.doFilter(SecurityFilter.java:135)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
	at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:68)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:57)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:213)
	at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:64)
	at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:35)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:298)
	... 47 more
Caused by: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:870)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:201)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:209)
	... 50 more

Howdy Greenhorn.

Have you run out of database connections? Get your resource monitor counting them.

-Cameron McKenzie

Hi Cameron McKenzie,

May i know how to check the resource monitor?

The DB for the application is MS SOL 2005.

The hibernate.cfg.xml configuration for cfg part is as below. Is there any need to do adjustment?

<property name="connection.username">sa</property>
<property name="connection.password">password</property>
<property name="show_sql">false</property>
<property name="c3p0.acquire_increment">5</property>
<property name="c3p0.idle_test_period">10</property> 
<property name="c3p0.min_size">5</property>
<property name="c3p0.max_size">300</property>
<property name="c3p0.timeout">1</property>
<property name="c3p0.max_statements">300</property>

The Resource Monitor/Performance Monitor gets installed with the Application Server, I believe.

-Cameron McKenzie