Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

applicationContext.xml 文件

db.properties 文件

运行文件AppTest

运行报错：

D:\Java\bin\java.exe -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:55364,suspend=y,server=n -ea -Didea.test.cyclic.buffer.size=1048576 -javaagent:C:\Users\Administrator\AppData\Local\JetBrains\IntelliJIdea2020.1\captureAgent\debugger-agent.jar -Dfile.encoding=UTF-8 -classpath "D:\TK\IntelliJ IDEA 2020.1.2\lib\idea_rt.jar;D:\TK\IntelliJ IDEA 2020.1.2\plugins\junit\lib\junit5-rt.jar;D:\TK\IntelliJ IDEA 2020.1.2\plugins\junit\lib\junit-rt.jar;D:\javaee\cld\code3\target\test-classes;D:\javaee\cld\code3\target\classes;D:\m2\repository\junit\junit\4.11\junit-4.11.jar;D:\m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\m2\repository\org\mybatis\mybatis\3.5.6\mybatis-3.5.6.jar;D:\m2\repository\org\mybatis\mybatis-spring\2.0.5\mybatis-spring-2.0.5.jar;D:\m2\repository\mysql\mysql-connector-java\8.0.22\mysql-connector-java-8.0.22.jar;D:\m2\repository\com\google\protobuf\protobuf-java\3.11.4\protobuf-java-3.11.4.jar;D:\m2\repository\org\springframework\spring-context\5.3.1\spring-context-5.3.1.jar;D:\m2\repository\org\springframework\spring-aop\5.3.1\spring-aop-5.3.1.jar;D:\m2\repository\org\springframework\spring-beans\5.3.1\spring-beans-5.3.1.jar;D:\m2\repository\org\springframework\spring-core\5.3.1\spring-core-5.3.1.jar;D:\m2\repository\org\springframework\spring-jcl\5.3.1\spring-jcl-5.3.1.jar;D:\m2\repository\org\springframework\spring-expression\5.3.1\spring-expression-5.3.1.jar;D:\m2\repository\org\springframework\spring-aspects\5.3.1\spring-aspects-5.3.1.jar;D:\m2\repository\org\aspectj\aspectjweaver\1.9.6\aspectjweaver-1.9.6.jar;D:\m2\repository\org\springframework\spring-orm\5.3.1\spring-orm-5.3.1.jar;D:\m2\repository\org\springframework\spring-jdbc\5.3.1\spring-jdbc-5.3.1.jar;D:\m2\repository\org\springframework\spring-tx\5.3.1\spring-tx-5.3.1.jar;D:\m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;D:\m2\repository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;D:\m2\repository\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;D:\m2\repository\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;D:\m2\repository\org\apache\maven\maven-model\2.0.9\maven-model-2.0.9.jar;D:\m2\repository\org\codehaus\plexus\plexus-utils\1.5.1\plexus-utils-1.5.1.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 org.example.AppTest,selectUserlist
Connected to the target VM, address: '127.0.0.1:55364', transport: 'socket'
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'Chen'@'localhost' (using password: YES))

    at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:309)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:578)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:365)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:134)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
    at com.sun.proxy.$Proxy22.selectUserlist(Unknown Source)
    at org.example.AppTest.selectUserlist(AppTest.java:30)
    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.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
    at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
    at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)
    at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:230)
    at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:58)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'Chen'@'localhost' (using password: YES))
    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:265)
    ... 31 more
Caused by: java.sql.SQLException: Access denied for user 'Chen'@'localhost' (using password: YES)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836)
    at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456)
    at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246)
    at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
    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)
    ... 34 more

Disconnected from the target VM, address: '127.0.0.1:55364', transport: 'socket'

Process finished with exit code -1
 

system-properties-mode 一共有四个值：

• SYSTEM_ PROPERTIES_ MODE FALLBACK模式：默认在指定的properties文件中找不到你要的属性，它还会在Java的System类属性中查找。
• SYSTEM_ PROPERTIES_ MODE_ NEVER模式：允许在properties文件中查找,允许去System类中查找。
• SYSTEM_ PROPERTIES_ MODE_ OVERRIDE模式：优先System类中查找,找不到再去properties文件中查找
• ENVIRONMENT：和OVERRIDE类似

解决方法：

运行成功