org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

2023-08-04 09:51:58

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

这个问题困扰许久，许久。原来只是data source的properties引入文件，el表达式前必须加jdbc

原文解决参考：http://blog.csdn.net/liwuyang2013/article/details/25986597

org.apache.ibatis.exceptions.PersistenceException:

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: YES))

### The error may exist in mapper/CustomerMapper.xml

### The error may involve com.zhexiang.mybatis_springmvc.model.selectCustomerByID

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: YES))

  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:)

  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:)

  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:)

  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:)

  at com.zhexiang.mybatis_springmvc.dao.impl.CustomerDaoImpl.selectCustomerByID(CustomerDaoImpl.java:)

  at com.zhexiang.mybatis_springmvc.dao.impl.CustomerDaoImplTest.testSelectCustomerByID(CustomerDaoImplTest.java:)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:)

  at java.lang.reflect.Method.invoke(Method.java:)

  at junit.framework.TestCase.runTest(TestCase.java:)

  at junit.framework.TestCase.runBare(TestCase.java:)

  at junit.framework.TestResult$.protect(TestResult.java:)

  at junit.framework.TestResult.runProtected(TestResult.java:)

  at junit.framework.TestResult.run(TestResult.java:)

  at junit.framework.TestCase.run(TestCase.java:)

  at junit.framework.TestSuite.runTest(TestSuite.java:)

  at junit.framework.TestSuite.run(TestSuite.java:)

  at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:)

  at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:)

  at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:)

  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:)

  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:)

  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:)

  at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:)

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: YES))

  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:)

  at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:)

  at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:)

  at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:)

  at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:)

  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:)

  at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:)

  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:)

  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:)

  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:)

  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:)

  ...  more

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'root '@'localhost' (using password: YES))

  at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:)

  at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:)

  at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:)

  at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:)

  at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:)

  ...  more

Caused by: java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES)

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

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

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

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

  at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:)

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

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

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

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

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

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

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

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

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

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

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

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

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

  at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:)

  at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:)

  at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:)

  at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:)

  ...  more

出现以上错误原因是：数据源的错误配置：

错误的jdbc.properties

driver=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=gbk

username=root

password=root

错误的spring配置文件：

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">

  <!--  config db property file location  -->

  <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

    <property name="locations" value="classpath:jdbc.properties"/>

  </bean>

  <bean id="dataSource" destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" >

        <property name="driverClassName" value="${driver}"/>

        <property name="url" value="${url}" />

        <property name="username" value="${username}" />

        <property name="password" value="${password}" />

 </beans>

正确的jdbc.properties配置：

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=gbk

jdbc.username=root

jdbc.password=root

Spring4.0.4 官方文档数据源配置：

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xmlns:context="http://www.springframework.org/schema/context"

  xsi:schemaLocation="

    http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

    http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-3.0.xsd">

  <!-- Scans within the base package of the application for @Components to configure as beans -->

  <context:component-scan base-package="org.springframework.docs.test" />

  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

    <property name="driverClassName" value="${jdbc.driverClassName}"/>

    <property name="url" value="${jdbc.url}"/>

    <property name="username" value="${jdbc.username}"/>

    <property name="password" value="${jdbc.password}"/>

  </bean>

  <context:property-placeholder location="jdbc.properties"/>

</beans>
叼叼叼，楼主我都想请你吃饭了，这个问题困扰了我将近三天时间。jdbc什么我都配好了，就是出不来，网上的例子也大都千律一篇。赞
上一篇：Retrofit提交Json


下一篇：python的数据库链接