3回答

• 

  慕盖茨4805442

  2016-05-18 10:25:08

  已采纳

  /// 可以省略localhost 

  1 0

  java家洼

  非常感谢！

  2016-05-18 13:51:05

  共 1 条回复 >

• 

  java家洼

  2016-05-14 11:11:39

  我改成两个斜杠，运行的时候出现了错误：
  [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个斜杠就出错了，你说的好像不对吧，那为什么要改成两个斜杠，你能给个理由吗？为什么要改成两个斜杠？我要的是理由，而不是简单的“是”或者“不是”。
  

  0 0
• 

  慕九州7813634

  2016-05-14 10:14:46

  一般两斜杠就行  三斜杠可能误写。。。。
  

  1 0

  java家洼

  你说的好像不对吧，我试验了你的说法，结果出错了。

  2016-05-14 11:12:18

  共 1 条回复 >