Last packet sent to the server was 0 ms ago. ?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847) ?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555) ?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) ?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) ?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) ?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) ?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) ?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) ?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) [SpringTransaction] 2016-05-14 11:11:59?? com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@16f5261 -- 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). Last acquisition attempt exception: ? com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
Last packet sent to the server was 0 ms ago. ?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847) ?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555) ?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) ?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134) ?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) ?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) ?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) ?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) ?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) [SpringTransaction] 2016-05-14 11:11:59?? com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@174a6e2 -- 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). Last acquisition attempt exception: ? com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
2016-05-18
/// 可以省略localhost?
2016-05-14
我改成兩個斜杠，運行的時候出現了錯誤：
[SpringTransaction] 2016-05-14 11:11:28?? Loading XML bean definitions from class path resource [applicationContext.xml]
[SpringTransaction] 2016-05-14 11:11:28?? Refreshing org.springframework.context.support.GenericApplicationContext@64ab4d: startup date [Sat May 14 11:11:28 CST 2016]; root of context hierarchy
[SpringTransaction] 2016-05-14 11:11:28?? Loading properties file from class path resource [jdbc.properties]
[SpringTransaction] 2016-05-14 11:11:28?? Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@a2220f: defining beans [org.springframework.context.support.PropertySourcesPlaceholderConfigurer#0,dataSource,accountService,accountDao,transactionManager,transactionTemplate,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; root of factory hierarchy
[SpringTransaction] 2016-05-14 11:11:28?? MLog clients using log4j logging.
[SpringTransaction] 2016-05-14 11:11:28?? Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
[SpringTransaction] 2016-05-14 11:11:29?? Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge0ys9g1c2ip65l9iz2a|1aecc3a, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge0ys9g1c2ip65l9iz2a|1aecc3a, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://spring_transaction, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 15, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 3, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
[SpringTransaction] 2016-05-14 11:11:59?? com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@9be2b5 -- 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). Last acquisition attempt exception: ?
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.UnknownHostException
MESSAGE: spring_transaction
STACKTRACE:
java.net.UnknownHostException: spring_transaction
?? ?at java.net.InetAddress.getAllByName0(InetAddress.java:1157)
?? ?at java.net.InetAddress.getAllByName(InetAddress.java:1083)
?? ?at java.net.InetAddress.getAllByName(InetAddress.java:1019)
?? ?at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)
?? ?at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
[SpringTransaction] 2016-05-14 11:11:59?? com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@16f5261 -- 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). Last acquisition attempt exception: ?
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.UnknownHostException
MESSAGE: spring_transaction
STACKTRACE:
java.net.UnknownHostException: spring_transaction
?? ?at java.net.InetAddress.getAllByName0(InetAddress.java:1157)
?? ?at java.net.InetAddress.getAllByName(InetAddress.java:1083)
?? ?at java.net.InetAddress.getAllByName(InetAddress.java:1019)
?? ?at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)
?? ?at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.
?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
[SpringTransaction] 2016-05-14 11:11:59?? com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@174a6e2 -- 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). Last acquisition attempt exception: ?
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.UnknownHostException
MESSAGE: spring_transaction
STACKTRACE:
java.net.UnknownHostException: spring_transaction
?? ?at java.net.InetAddress.getAllByName0(InetAddress.java:1157)
?? ?at java.net.InetAddress.getAllByName(InetAddress.java:1083)
?? ?at java.net.InetAddress.getAllByName(InetAddress.java:1019)
?? ?at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246)
?? ?at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
** END NESTED EXCEPTION **
Last packet sent to the server was 2 ms ago.
?? ?at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
?? ?at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
?? ?at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
?? ?at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)
?? ?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$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
?? ?at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
?? ?at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
[SpringTransaction] 2016-05-14 11:11:59?? Closing org.springframework.context.support.GenericApplicationContext@64ab4d: startup date [Sat May 14 11:11:28 CST 2016]; root of context hierarchy
[SpringTransaction] 2016-05-14 11:11:59?? Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@a2220f: defining beans [org.springframework.context.support.PropertySourcesPlaceholderConfigurer#0,dataSource,accountService,accountDao,transactionManager,transactionTemplate,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor]; root of factory hierarchy
但是3個斜杠運行起來就沒有錯誤，而改成2個斜杠就出錯了，你說的好像不對吧，那為什么要改成兩個斜杠，你能給個理由嗎？為什么要改成兩個斜杠？我要的是理由，而不是簡單的“是”或者“不是”。
2016-05-14
一般兩斜杠就行? 三斜杠可能誤寫。。。。