File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes A ResourcePool could not acquire a resource from its primary factory or source. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "A ResourcePool could not acquire a resource from its primary factory or source." Watch "A ResourcePool could not acquire a resource from its primary factory or source." New topic
Author

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

Elizabeth Liew
Greenhorn

Joined: Jun 04, 2008
Posts: 6
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

Joined: Aug 26, 2006
Posts: 4968
    
    1

Howdy Greenhorn.

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

-Cameron McKenzie
Elizabeth Liew
Greenhorn

Joined: Jun 04, 2008
Posts: 6
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

Joined: Aug 26, 2006
Posts: 4968
    
    1

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

-Cameron McKenzie
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: A ResourcePool could not acquire a resource from its primary factory or source.