Home > Back-end >  A JDBC connection SQLserver2012 error warning: com. McHange. V2. Resourcepool. $AcquireTa BasicResou
A JDBC connection SQLserver2012 error warning: com. McHange. V2. Resourcepool. $AcquireTa BasicResou

Time:12-06

Error message
On May 28, 2017 11:05:48 morning org. Springframework. Context. Support. ClassPathXmlApplicationContext prepareRefresh
Information: Refreshing org. Springframework. Context. Support the ClassPathXmlApplicationContext @ 67424 e82: startup date [Sun May 28 11:05:48 CST 2017]. The root of the context hierarchy
On May 28, 2017 11:05:48 morning org. Springframework. Beans. Factory. XML. XmlBeanDefinitionReader loadBeanDefinitions
Information: Loading XML bean definitions from the class path resource/work/applicationContext. XML
On May 28, 2017 com 11:05:49 morning. McHange. V2. The MLog & lt; clinit>
Information: the MLog clients using Java 1.4 + standard logging.
On May 28, 2017 com 11:05:49 morning. McHange. V2. C3p0. C3P0Registry banner
Information: the Initializing c3p0-0.9.1.2 [built 21 - May - 2007 15:04:56; debug? True; trace: 10]
On May 28, 2017 com 11:05:49 morning. McHange. V2. C3p0. Impl. AbstractPoolBackedDataSource getPoolManager
Information: the Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> ytcuiv9oldatyw12hjuql|3f49dace, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> ytcuiv9oldatyw12hjuql|3f49dace, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://127.0.0.1:49267;databaseName=checkgrade, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 10, maxStatements -> 100, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
On May 28, 2017 com 11:06:19 morning. McHange. V2. Resourcepool. BasicResourcePool $AcquireTask run
Warning: com. McHange. V2. Resourcepool. BasicResourcePool $AcquireTask @ 161 e7f12 - Acquisition Attempt Failed!!!!!! Clearing the pending acquires. While trying to acquire a men new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). The Last acquisition attempt exception:
Java. SQL. SQLException: Login failed for user 'spuser.
At net. Sourceforge. JTDS. JDBC. SQLDiagnostic. AddDiagnostic (SQLDiagnostic. Java: 368)
At net. Sourceforge. JTDS. JDBC. TdsCore. TdsErrorToken (TdsCore. Java: 2816)
At net. Sourceforge. JTDS. JDBC. TdsCore. NextToken (TdsCore. Java: 2254)
At net. Sourceforge. JTDS. JDBC. TdsCore. Login (TdsCore. Java: 602)
At net. Sourceforge. JTDS. JDBC. ConnectionJDBC2. & lt; init> (ConnectionJDBC2. Java: 344)
At net. Sourceforge. JTDS. JDBC. ConnectionJDBC3. & lt; init> (ConnectionJDBC3. Java: 50)
At net. Sourceforge. JTDS.. JDBC Driver. Connect (182) Driver. Java:
At com. McHange. V2. C3p0. DriverManagerDataSource. GetConnection (134). DriverManagerDataSource Java:
At com. McHange. V2. C3p0. WrapperConnectionPoolDataSource. GetPooledConnection (WrapperConnectionPoolDataSource. Java: 182)
At com. McHange. V2. C3p0. WrapperConnectionPoolDataSource. GetPooledConnection (WrapperConnectionPoolDataSource. Java: 171)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool $1 pooledconnectionresourcepoolmanager. AcquireResource (C3P0PooledConnectionPool. Java: 137)
At com. McHange. V2. Resourcepool. BasicResourcePool. DoAcquire (BasicResourcePool. Java: 1014)
At com. McHange. V2. Resourcepool. BasicResourcePool. Access the $800 (BasicResourcePool. Java: 32)
At com. McHange. V2. Resourcepool. BasicResourcePool $AcquireTask. Run (1810) BasicResourcePool. Java:
At com. McHange. V2. Async. ThreadPoolAsynchronousRunner $PoolThread. Run (547) ThreadPoolAsynchronousRunner. Java:

Java. SQL. SQLException: Connections could not be acquired from the physicist database!
At com. McHange. V2. SQL. SqlUtils. ToSQLException (SqlUtils. Java: 106)
At com. McHange. V2. C3p0. Impl. C3P0PooledConnectionPool. CheckoutPooledConnection (C3P0PooledConnectionPool. Java: 529)
At com. McHange. V2. C3p0. Impl. AbstractPoolBackedDataSource. GetConnection (AbstractPoolBackedDataSource. Java: 128)
5. Test. The main (test. Java: 26)
Under 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. AwaitAvailable (BasicResourcePool. Java: 1319)
At com. McHange. V2. Resourcepool. BasicResourcePool. PrelimCheckoutResource (BasicResourcePool. Java: 557)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
  • Related