Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Elizabeth Liew
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Howdy Greenhorn.

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

-Cameron McKenzie
 
Elizabeth Liew
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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> <!-- seconds -->
<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>
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The Resource Monitor/Performance Monitor gets installed with the Application Server, I believe.

-Cameron McKenzie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic