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.

    XMLWordPrintableJSON

Details

    • Question
    • Status: Closed
    • Critical
    • Resolution: Invalid
    • None
    • 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

            Unassigned Unassigned
            diego.villecco@11x.com.ar diego.villecco@11x.com.ar
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: