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