测试dao单元时候好像数据库访问不进去

Question

二月 12, 2018 10:47:27 下午 org.springframework.test.context.support.DefaultTestContextBootstrapper getDefaultTestExecutionListenerClassNames

信息: Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]

二月 12, 2018 10:47:27 下午 org.springframework.test.context.support.DefaultTestContextBootstrapper getTestExecutionListeners

信息: Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@3567135c, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@327471b5, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@4157f54e, org.springframework.test.context.support.DirtiesContextTestExecutionListener@90f6bfd, org.springframework.test.context.transaction.TransactionalTestExecutionListener@47f6473, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@15975490]

二月 12, 2018 10:47:27 下午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions

信息: Loading XML bean definitions from class path resource [spring/spring-dao.xml]

二月 12, 2018 10:47:27 下午 org.springframework.context.support.GenericApplicationContext prepareRefresh

信息: Refreshing org.springframework.context.support.GenericApplicationContext@28feb3fa: startup date [Mon Feb 12 22:47:27 CST 2018]; root of context hierarchy

二月 12, 2018 10:47:27 下午 com.mchange.v2.log.MLog <clinit>

信息: MLog clients using java 1.4+ standard logging.

二月 12, 2018 10:47:27 下午 com.mchange.v2.c3p0.C3P0Registry banner

信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]

22:47:27.988 [main] DEBUG org.apache.ibatis.logging.LogFactory - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.

22:47:28.058 [main] DEBUG org.apache.ibatis.io.VFS - Class not found: org.jboss.vfs.VFS

22:47:28.058 [main] DEBUG org.apache.ibatis.io.JBoss6VFS - JBoss 6 VFS API is not available in this environment.

22:47:28.058 [main] DEBUG org.apache.ibatis.io.VFS - Class not found: org.jboss.vfs.VirtualFile

22:47:28.058 [main] DEBUG org.apache.ibatis.io.VFS - VFS implementation org.apache.ibatis.io.JBoss6VFS is not valid in this environment.

22:47:28.059 [main] DEBUG org.apache.ibatis.io.VFS - Using VFS adapter org.apache.ibatis.io.DefaultVFS

22:47:28.059 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Find JAR URL: file:/C:/Users/x811/eclipse-workspace/Market/target/classes/com/xiehe/market/entity

22:47:28.059 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Not a JAR: file:/C:/Users/x811/eclipse-workspace/Market/target/classes/com/xiehe/market/entity

22:47:28.093 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: Area.class

22:47:28.094 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: HeadLine.class

22:47:28.094 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: LocalAuth.class

22:47:28.094 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: PersonInfo.class

22:47:28.095 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: Product.class

22:47:28.095 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: ProductCategory.class

22:47:28.095 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: ProductImg.class

22:47:28.096 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: Shop.class

22:47:28.096 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: ShopCategory.class

22:47:28.096 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: WecharAuth.class

22:47:28.096 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Listing file:/C:/Users/x811/eclipse-workspace/Market/target/classes/com/xiehe/market/entity

22:47:28.097 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Find JAR URL: file:/C:/Users/x811/eclipse-workspace/Market/target/classes/com/xiehe/market/entity/Area.class

22:47:28.097 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Not a JAR: file:/C:/Users/x811/eclipse-workspace/Market/target/classes/com/xiehe/market/entity/Area.class

22:47:28.097 [main] DEBUG org.apache.ibatis.io.DefaultVFS - Reader entry: ����

Answer 1

提问者 慕设计9144567 2018-02-12 23:15:58

老师我找到了。  千算万算.....数据库名字错了一个market  写成 marker.... t和 r 在jdbc.properties文件里面

现在ok了..... 下次一定要认真... 谢谢老师

• 翔仔 #1

  同学好，多看看错误 一般在cause by附近 看自己能看懂的即可：）

• 提问者 慕设计9144567 回复 翔仔 #2

  恩恩已经可以了。jdbc.properties文件  数据库名字错了一个字幕。。低级错误。TAT

Answer 2

提问者 慕设计9144567 2018-02-12 22:51:23

二月 12, 2018 10:47:28 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource getPoolManager

信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 2, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 10000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hge1389t12factdx2lz1e|4b14c583, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hge1389t12factdx2lz1e|4b14c583, idleConnectionTestPeriod -> 0, initialPoolSize -> 3, jdbcUrl -> jdbc:mysql://localhost:3306/marker?useUnicode=true&characterEncoding=utf8, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 30, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 10, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]

二月 12, 2018 10:47:29 下午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run

警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@55d8da62 -- 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 (2). Last acquisition attempt exception: 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'marker'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:928)

at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4736)

at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1342)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2493)

at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2526)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2311)

at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)

at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)

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)

二月 12, 2018 10:47:29 下午 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run

警告: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@5617745e -- 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 (2). Last acquisition attempt exception: 

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'marker'

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)