java.sql.SQLException: Connections could not be acquired from the underlying database!

0

Holas

I am working with hibernate and I have a problem with my application, it does not connect me to the database (sql).

When I look at the tomcat log, I find this:

  

(e-deas LTDA / CFC) [2018-04-27 10: 05: 40,830] | WARN | com.mchange.v2.resourcepool.BasicResourcePool $ AcquireTask | BasicResourcePool: 1222 | com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@64dc420b - Acquisition Attempt Failed !!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30).       (e-deas LTDA / CFC) [2018-04-27 10: 05: 40,846] | WARN | org.hibernate.cfg.SettingsFactory | SettingsFactory: 103 | Could not obtain connection metadata       java.sql.SQLException: Connections could not be acquired from the underlying database!           at com.mchange.v2.sql.SqlUtils.toSQLException (SqlUtils.java:104)           at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection (C3P0PooledConnectionPool.java:236)           at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection (PoolBackedDataSource.java:94)           at org.hibernate.connection.C3P0ConnectionProvider.getConnection (C3P0ConnectionProvider.java:35)           at org.hibernate.cfg.SettingsFactory.buildSettings (SettingsFactory.java:72)           at org.hibernate.cfg.Configuration.buildSettings (Configuration.java:1881)           at org.hibernate.cfg.Configuration.buildSessionFactory (Configuration.java:1174)           at com.edeas.hibernate.HibernateSessionFactory. (HibernateSessionFactory.java:31)           at com.edeas.hibernate.BaseHibernateDAO.getSession (BaseHibernateDAO.java:12)           at com.edeas.eParametrizacion.modelo.dao.CompaniaDAO. (CompaniaDAO.java:49)           at com.edeas.eParametrizacion.logica.CompaniaAction.findbyPrefix (CompaniaAction.java:233)           at com.edeas.eSolicyTransp.logica.FileUploadAction.processFile (FileUploadAction.java:312)           at com.edeas.eSolicyTransp.logica.CargaAutomaticaFacturaAction.execute (AutomaticAutomationActivityAction.java:122)           at org.quartz.core.JobRunShell.run (JobRunShell.java:202)           at org.quartz.simpl.SimpleThreadPool $ WorkerThread.run (SimpleThreadPool.java:529)       Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.           at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire (BasicResourcePool.java:970)           at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource (BasicResourcePool.java:208)           at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection (C3P0PooledConnectionPool.java:232)           ... 13 more

My properties for the file hibernate.cfg.xml are these:

<property name="connection.username">xxx</property>
        <property name="connection.password">xxx</property>
        <property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
        <property name="connection.url">
            jdbc:sqlserver://10.60.1.132\xxxx;databaseName=db_CtrlFletes_dev
        </property> 


<property name="myeclipse.connection.profile">
            SQLServer (BD_CtrlFletes)
        </property>
        <property name="dialect">
            org.hibernate.dialect.SQLServerDialect
        </property>
        <property name="hibernate.query.factory_class">
            org.hibernate.hql.ast.ASTQueryTranslatorFactory
        </property>



<property name="connection.pool_size">20</property>
        <property name="connection.autoReconnect">true</property>
        <property name="connection.autoReconnectForPool">true</property>

        <property name="hibernate.c3p0.min_size">0</property>
        <property name="hibernate.c3p0.max_size">250</property>
        <property name="hibernate.c3p0.timeout">60</property>
        <property name="hibernate.c3p0.max_statements">0</property>
        <property name="hibernate.c3p0.idle_test_period">30</property>
        <property name="hibernate.c3p0.acquire_increment">5</property>

        <property name="c3p0.autoCommitOnClose">false</property>
        <property name="c3p0.testConnectionOnCheckin">false</property>
        <property name="default_batch_fetch_size">20</property>

        <property name="c3p0.testConnectionOnCheckout">true</property>
        <property name="c3p0.acquireRetryDelay">1000</property>
        <property name="c3p0.acquireRetryAttempts">1</property>

        <property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
        <property name="hibernate.c3p0.max_statements_per_connection">100</property>

If someone could help me, I would really appreciate it.

Thanks

    
asked by Andres Castañeda Marin 27.04.2018 в 18:29
source

0 answers