【Java】 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

柔情只为你懂 2021-09-29 07:34 1026阅读 0赞

**【问题描述】**

今天在使用ssm框架搭建项目，启动tomcat的时候遇到了如下的错误：

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:26)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:111)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66)
    	at com.zhexiang.mybatis_springmvc.dao.impl.CustomerDaoImpl.selectCustomerByID(CustomerDaoImpl.java:18)
    	at com.zhexiang.mybatis_springmvc.dao.impl.CustomerDaoImplTest.testSelectCustomerByID(CustomerDaoImplTest.java:37)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    	at java.lang.reflect.Method.invoke(Method.java:597)
    	at junit.framework.TestCase.runTest(TestCase.java:176)
    	at junit.framework.TestCase.runBare(TestCase.java:141)
    	at junit.framework.TestResult$1.protect(TestResult.java:122)
    	at junit.framework.TestResult.runProtected(TestResult.java:142)
    	at junit.framework.TestResult.run(TestResult.java:125)
    	at junit.framework.TestCase.run(TestCase.java:129)
    	at junit.framework.TestSuite.runTest(TestSuite.java:255)
    	at junit.framework.TestSuite.run(TestSuite.java:250)
    	at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
    	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
    	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
    	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
    	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
    	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
    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:80)
    	at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:81)
    	at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67)
    	at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
    	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:72)
    	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59)
    	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
    	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
    	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
    	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
    	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
    	... 23 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: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.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
    	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
    	... 33 more
    Caused by: java.sql.SQLException: Access denied for user 'root '@'localhost' (using password: YES)
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
    	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:925)
    	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1704)
    	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1250)
    	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2465)
    	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2498)
    	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283)
    	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:822)
    	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404)
    	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317)
    	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)
    	... 37 more

**【问题原因】**

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

（1）jdbc.properties文件

driver=oracle.jdbc.driver.OracleDriver
    url=jdbc:oracle:thin:@ip:1521:xzw
    username=root
    password=root

（2）Spring配置文件

<bean id="dataSource" 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}" />
      </bean>
      
      <context:property-placeholder location="classpath:jdbc.properties"/>

上面的这两种写法是错误的。

**【解决办法】**

（1）jdbc.properties文件

jdbc.driver=oracle.jdbc.driver.OracleDriver
    jdbc.url=jdbc:oracle:thin:@ip:1521:xzw
    jdbc.username=root
    jdbc.password=root

（2）Spring配置文件

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
      	<property name="driverClassName" value="${jdbc.driver}" />
      	<property name="url" value="${jdbc.url}" />
      	<property name="username" value="${jdbc.username}" />
      	<property name="password" value="${jdbc.password}" />
      </bean>
      
      <context:property-placeholder location="classpath:jdbc.properties"/>

重新启动tomcat，问题已解决~

【Java】 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关【mysql】org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

相关 jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题

相关 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection 问题处理

相关 Oracle数据源:org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection;

相关 Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nes

相关 Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not

相关报Could not get JDBC Connection的错误

相关 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection java.sql.SQ

相关【Java】 org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection

相关 org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for