[jira] Commented: (WOOKIE-13) java.sql.SQLException: Connections could not be acquired from the underlying database!

["diego.villecco@11x.com.ar (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/WOOKIE-13?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12833433#action_12833433 ] 

diego.villecco@11x.com.ar commented on WOOKIE-13:
-------------------------------------------------

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_11xar101The 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@Argentina


> java.sql.SQLException: Connections could not be acquired from the underlying database! 
> ---------------------------------------------------------------------------------------
>
>                 Key: WOOKIE-13
>                 URL: https://issues.apache.org/jira/browse/WOOKIE-13
>             Project: Wookie
>          Issue Type: Bug
>          Components: Documentation
>         Environment: tomcat6.0.18, MySQL 5.1
>            Reporter: Prabhu Pathak
>            Assignee: Scott Wilson
>            Priority: Minor
>             Fix For: 0.8.1
>
>   Original Estimate: 0.33h
>          Time Spent: 0.33h
>  Remaining Estimate: 0h
>
> I am using : wookie_for_tomcat_20090601
> Apache Tomcat Version 6.0.18
> Error : java.sql.SQLException: Connections could not be acquired from the underlying database!
> 	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
> Solution :
> \Tomcat 6.0\webapps\wookie\WEB-INF\classes\hibernate.cfg : inserted  password property to root user.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.