Uploaded image for project: 'Community Development'
  1. Community Development
  2. COMDEV-16

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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Question
    • Status: Closed
    • Priority: Critical
    • Resolution: Invalid
    • Component/s: None
    • Labels:
    • Environment:
      Tomcat, Hibernate, Postgresql

      Description

      Hi, hopefully you can help me, I am stuck with this error.

      My site works great locally but when deployed at the server I get the following error, you can see it at 11x.com.ar

      java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire

      I am using hibernate and postgresql.
      The db is created with name toyta01_11xar101
      The hibernate.cfg.xml file defines:
      <property name="hibernate.connection.driver_class">org.postgresql.Driver</property><property name="hibernate.connection.url">jdbc:postgresql://localhost/toyta01_11xar101</property><property name="hibernate.connection.username">toyta01_fana</property><property name="hibernate.connection.password">***</property><property name="hibernate.connection.shutdown">true</property><property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property><property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property><property name="show_sql">true</property><property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property> I just removed the password here, I understand. Then I have<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property><property name="hibernate.c3p0.max_size">20</property><property name="hibernate.c3p0.min_size">0</property><property name="hibernate.c3p0.timeout">5000</property><property name="hibernate.c3p0.max_statements">100</property><property name="hibernate.c3p0.idle_test_period">3000</property><property name="hibernate.c3p0.acquire_increment">2</property> User toyta01_fana has enough privileges. Thanks in advance. Diego

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              diego.villecco@11x.com.ar diego.villecco@11x.com.ar

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment