运行精通spring4.x企业应用开发实战第二章随书自带项目的测试类时报错

weixin_38051760 2019-05-27 09:11:34

开发四年只会写业务代码，分布式高并发都不会还做程序员？->>>

C:\Java\jdk-11.0.2\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\IDE\IntelliJ IDEA 2019.1.2\lib\idea_rt.jar=50231:C:\IDE\IntelliJ IDEA 2019.1.2\bin" -Dfile.encoding=UTF-8 -classpath "C:\IDE\IntelliJ IDEA 2019.1.2\lib\idea_rt.jar;C:\IDE\IntelliJ IDEA 2019.1.2\plugins\testng\lib\testng-plugin.jar;C:\masterSpring\code\chapter2\target\test-classes;C:\masterSpring\code\chapter2\target\classes;C:\Maven\localRepository\org\springframework\spring-beans\4.2.2.RELEASE\spring-beans-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-core\4.2.2.RELEASE\spring-core-4.2.2.RELEASE.jar;C:\Maven\localRepository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;C:\Maven\localRepository\org\springframework\spring-context\4.2.2.RELEASE\spring-context-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-aop\4.2.2.RELEASE\spring-aop-4.2.2.RELEASE.jar;C:\Maven\localRepository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Maven\localRepository\org\springframework\spring-expression\4.2.2.RELEASE\spring-expression-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-context-support\4.2.2.RELEASE\spring-context-support-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-jdbc\4.2.2.RELEASE\spring-jdbc-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-tx\4.2.2.RELEASE\spring-tx-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-webmvc\4.2.2.RELEASE\spring-webmvc-4.2.2.RELEASE.jar;C:\Maven\localRepository\org\springframework\spring-web\4.2.2.RELEASE\spring-web-4.2.2.RELEASE.jar;C:\Maven\localRepository\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;C:\Maven\localRepository\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;C:\Maven\localRepository\mysql\mysql-connector-java\5.1.29\mysql-connector-java-5.1.29.jar;C:\Maven\localRepository\javax\servlet\servlet-api\3.0-alpha-1\servlet-api-3.0-alpha-1.jar;C:\Maven\localRepository\org\aspectj\aspectjweaver\1.8.1\aspectjweaver-1.8.1.jar;C:\Maven\localRepository\org\testng\testng\6.8.7\testng-6.8.7.jar;C:\Maven\localRepository\junit\junit\4.10\junit-4.10.jar;C:\Maven\localRepository\org\hamcrest\hamcrest-core\1.1\hamcrest-core-1.1.jar;C:\Maven\localRepository\org\beanshell\bsh\2.0b4\bsh-2.0b4.jar;C:\Maven\localRepository\com\beust\jcommander\1.27\jcommander-1.27.jar;C:\Maven\localRepository\org\yaml\snakeyaml\1.12\snakeyaml-1.12.jar;C:\Maven\localRepository\org\springframework\spring-test\4.2.2.RELEASE\spring-test-4.2.2.RELEASE.jar;C:\Maven\localRepository\javax\servlet\jstl\1.2\jstl-1.2.jar;C:\IDE\IntelliJ IDEA 2019.1.2\plugins\testng\lib\jcommander-1.27.jar" org.testng.RemoteTestNGStarter -usedefaultlisteners false -socket50230 @w @C :\Users\Darksound\AppData\Local\Temp\idea_working_dirs_testng.tmp -temp C:\Users\Darksound\AppData\Local\Temp\idea_testng.tmp
5月 27, 2019 9:01:06 上午 org.springframework.test.context.support.DefaultTestContextBootstrapper getTestExecutionListeners
信息: Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@65d09a04, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@33c911a1, org.springframework.test.context.support.DependencyInjectionTestExecutionListener@75db5df9, org.springframework.test.context.support.DirtiesContextTestExecutionListener@707194ba, org.springframework.test.context.transaction.TransactionalTestExecutionListener@1190200a, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@6a2f6f80]
[TestNG] Running:
C:\Users\Darksound\.IntelliJIdea2019.1\system\temp-testng-customsuite.xml
5月 27, 2019 9:01:06 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
信息: Loading XML bean definitions from URL [file:/C:/masterSpring/code/chapter2/target/classes/smart-context.xml]
5月 27, 2019 9:01:07 上午 org.springframework.context.support.GenericApplicationContext prepareRefresh
信息: Refreshing org.springframework.context.support.GenericApplicationContext@f5acb9d: startup date [Mon May 27 09:01:07 CST 2019]; root of context hierarchy
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by org.springframework.cglib.core.ReflectUtils$2 (file:/C:/Maven/localRepository/org/springframework/spring-core/4.2.2.RELEASE/spring-core-4.2.2.RELEASE.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain)
WARNING: Please consider reporting this to the maintainers of org.springframework.cglib.core.ReflectUtils$2
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
5月 27, 2019 9:01:07 上午 org.springframework.test.context.TestContextManager beforeTestMethod
警告: Caught exception while allowing TestExecutionListener [org.springframework.test.context.transaction.TransactionalTestExecutionListener@1190200a] to process 'before' execution of test method [public void com.smart.service.UserServiceTest.testAddLoginLog()] for test instance [com.smart.service.UserServiceTest@482bce4f]
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
   at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
   at org.springframework.test.context.transaction.TransactionContext.startTransaction(TransactionContext.java:98)
   at org.springframework.test.context.transaction.TransactionalTestExecutionListener.beforeTestMethod(TransactionalTestExecutionListener.java:194)
   at org.springframework.test.context.TestContextManager.beforeTestMethod(TestContextManager.java:265)
   at org.springframework.test.context.testng.AbstractTestNGSpringContextTests.springTestContextBeforeTestMethod(AbstractTestNGSpringContextTests.java:162)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.base/java.lang.reflect.Method.invoke(Method.java:566)
   at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)
   at org.testng.internal.Invoker.invokeConfigurationMethod(Invoker.java:564)
   at org.testng.internal.Invoker.invokeConfigurations(Invoker.java:213)
   at org.testng.internal.Invoker.invokeMethod(Invoker.java:653)
   at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
   at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
   at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
   at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
   at org.testng.TestRunner.privateRun(TestRunner.java:767)
   at org.testng.TestRunner.run(TestRunner.java:617)
   at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
   at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
   at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
   at org.testng.SuiteRunner.run(SuiteRunner.java:240)
   at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
   at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
   at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)
   at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)
   at org.testng.TestNG.run(TestNG.java:1057)
   at org.testng.IDEARemoteTestNG.run(IDEARemoteTestNG.java:73)
   at org.testng.RemoteTestNGStarter.main(RemoteTestNGStarter.java:123)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
   at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204)
   ... 30 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
   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:1015)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2584)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
   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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
   at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
   ... 33 more
Caused by: java.lang.NullPointerException
   at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3303)
   at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1987)
   at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1913)
   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
   ... 47 more

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)

   at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
   at org.springframework.test.context.transaction.TransactionContext.startTransaction(TransactionContext.java:98)
   at org.springframework.test.context.transaction.TransactionalTestExecutionListener.beforeTestMethod(TransactionalTestExecutionListener.java:194)
   at org.springframework.test.context.TestContextManager.beforeTestMethod(TestContextManager.java:265)
   at org.springframework.test.context.testng.AbstractTestNGSpringContextTests.springTestContextBeforeTestMethod(AbstractTestNGSpringContextTests.java:162)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.base/java.lang.reflect.Method.invoke(Method.java:566)
   at org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)
   at org.testng.internal.Invoker.invokeConfigurationMethod(Invoker.java:564)
   at org.testng.internal.Invoker.invokeConfigurations(Invoker.java:213)
   at org.testng.internal.Invoker.invokeMethod(Invoker.java:653)
   at org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
   at org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
   at org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
   at org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
   at org.testng.TestRunner.privateRun(TestRunner.java:767)
   at org.testng.TestRunner.run(TestRunner.java:617)
   at org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
   at org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
   at org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
   at org.testng.SuiteRunner.run(SuiteRunner.java:240)
   at org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
   at org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
   at org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)
   at org.testng.TestNG.runSuitesLocally(TestNG.java:1149)
   at org.testng.TestNG.run(TestNG.java:1057)
   at org.testng.IDEARemoteTestNG.run(IDEARemoteTestNG.java:73)
   at org.testng.RemoteTestNGStarter.main(RemoteTestNGStarter.java:123)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not create connection to database server.)
   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
   at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:204)
   ... 30 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
   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:1015)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2584)
   at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)
   at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
   at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
   at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
   at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
   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 org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
   at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
   at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
   ... 33 more
Caused by: java.lang.NullPointerException
   at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3303)
   at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1987)
   at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1913)
   at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1290)
   at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2502)
   at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)
   ... 47 more

电脑装的mysql是8.0.16的账号密码没问题 JDBC驱动换了5和8的都不行

...全文