java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

b4x.com | 4 months ago
  1. Speed up your debug routine!

    Automated exception search integrated into your IDE

  2. 0

    Hibernate Community • View topic - hibernate- C3P0ConnectionProvider running out of connection

    hibernate.org | 1 year ago
    java.sql.SQLException: com.mchange.v2.c3p0.PoolBackedDataSource@c46e7a40 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@15ce9731 [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 155h2bp8nfjie3i27t57o|39ea58, idleConnectionTestPeriod -> 60, initialPoolSize -> 5, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 360, maxIdleTimeExcessConnections -> 0, -> 100, maxStatements -> 75, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@10529244 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 155h2bp8nfjie3i27t57o|199197b, jdbcUrl -> jdbc:oracle:oci:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cnlxrd43)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = cnlxrd42)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = cnlxrd41)(PORT = 1526)) (ADDRESS = (PROTOCOL = TCP)(HOST = cnlxrd44)(PORT = 1526)) (enable=broken) (FAILOVER = ON) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = AEU) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5)))), properties -> {user=******, password=******} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 155h2bp8nfjie3i27t57o|c12978, numHelperThreads -> 100 ] has been closed() -- you can no longer use it.
  3. 0

    C3p0 Connections could not be acquired from the underlying database

    Stack Overflow | 10 months ago | Grace
    org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    An attempt by a client to checkout a Connection has timed out.

    at com.mchange.v2.sql.SqlUtils.toSQLException()
  2. c3p0:JDBC DataSources/Resource Pools
    AbstractPoolBackedDataSource.getConnection
    1. com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
    2. com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:77)
    3. com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:687)
    4. com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
    4 frames
  3. anywheresoftware.b4j.object
    ConnectionPool.GetConnection
    1. anywheresoftware.b4j.object.ConnectionPool.GetConnection(ConnectionPool.java:41)
    1 frame
  4. com.jmontserrat.postchatclient
    main._appstart
    1. com.jmontserrat.postchatclient.calendarupdate._requestasync(calendarupdate.java:222)
    2. com.jmontserrat.postchatclient.main._appstart(main.java:463)
    2 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  6. anywheresoftware.b4a
    BA.raiseEvent
    1. anywheresoftware.b4a.BA.raiseEvent2(BA.java:93)
    2. anywheresoftware.b4a.BA.raiseEvent(BA.java:84)
    2 frames
  7. com.jmontserrat.postchatclient
    main.start
    1. com.jmontserrat.postchatclient.main.start(main.java:35)
    1 frame
  8. com.sun.javafx
    PlatformImpl$6$1.run
    1. com.sun.javafx.application.LauncherImpl$8.run(Unknown Source)
    2. com.sun.javafx.application.PlatformImpl$7.run(Unknown Source)
    3. com.sun.javafx.application.PlatformImpl$6$1.run(Unknown Source)
    4. com.sun.javafx.application.PlatformImpl$6$1.run(Unknown Source)
    4 frames
  9. Java RT
    AccessController.doPrivileged
    1. java.security.AccessController.doPrivileged(Native Method)
    1 frame
  10. com.sun.javafx
    PlatformImpl$6.run
    1. com.sun.javafx.application.PlatformImpl$6.run(Unknown Source)
    1 frame
  11. com.sun.glass
    WinApplication$4$1.run
    1. com.sun.glass.ui.InvokeLaterDispatcher$Future.run(Unknown Source)
    2. com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
    3. com.sun.glass.ui.win.WinApplication.access$300(Unknown Source)
    4. com.sun.glass.ui.win.WinApplication$4$1.run(Unknown Source)
    4 frames
  12. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame