Could not get JDBC Connection

最新推荐文章于 2021-04-03 08:03:51 发布
最新推荐文章于 2021-04-03 08:03:51 发布
阅读量1.5k 收藏 1
点赞数
分类专栏： Exceptions-异常 文章标签： Could not get JDBC Connection Connection nested exception i
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhangminemail/article/details/79081819
版权 
org.mybatis.spring.MyBatisSystemException: nested exception is 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 load JDBC driver class 'com.mysql.jdbc.Driver  '
### The error may exist in file [D:\Workspaces\Private\tour\target\classes\com\zemel\mapping\UserMapper.xml]
### The error may involve com.zemel.dao.UserMapper.selectByPrimaryKey
### 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 load JDBC driver class 'com.mysql.jdbc.Driver  '
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
	at com.sun.proxy.$Proxy18.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	at com.sun.proxy.$Proxy19.selectByPrimaryKey(Unknown Source)
	at com.zemel.service.impl.UserServiceImpl.getUserById(UserServiceImpl.java:19)
	at com.zemel.test.TestMyBatis.test1(TestMyBatis.java:33)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	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.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:74)
	at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:83)
	at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:72)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:232)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:89)
	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.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:71)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:175)
	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.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 load JDBC driver class 'com.mysql.jdbc.Driver  '
### The error may exist in file [D:\Workspaces\Private\tour\target\classes\com\zemel\mapping\UserMapper.xml]
### The error may involve com.zemel.dao.UserMapper.selectByPrimaryKey
### 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 load JDBC driver class 'com.mysql.jdbc.Driver  '
	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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:601)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	... 35 more
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver  '
	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)
	... 42 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver  '
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	... 52 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver  
	at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:188)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
	... 55 more


2）分析问题：

jdbc连接不上；

可能的原因：驱动无效，驱动连接有误，驱动出问题了，

Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.mysql.jdbc.Driver  '
根据此提示发现com.mysql.jdbc.Driver配置多了一个空格

3）解决方案：

找到jdbc配置文件，果断去除空格



上官天夜
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
could not get jdbc connection mysql_Could not get JDBC Connection异常问题
weixin_33355385的博客
01-19 1839
此异常发生在整合SSM过程中.数据库的properties文件中 用户名的关键词写成了username, 导致报错无法连接db.properties文件如下:driver=com.mysql.cj.jdbc.Driverurl=jdbc:mysql:///how2java?serverTimezone=GMTusername=rootpassword=admin配置文件如下异常情况如下:### E...
could not get jdbc connection mysql_java连接mysql偶尔出现Could not get JDBC Connection
weixin_31108095的博客
01-19 533
||[ERROR][46703686][2018/05/29 10:15:27,631][ControllerAop.java][42][http-nio-8080-exec-19][发生异常]org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persistence...
could not get jdbc connection oracle,Docker中发布java web项目Could not get JDBC Connection
weixin_42514783的博客
04-03 162
项目是(spring+mybatis+oracle)docker是安装在虚拟机下面的，jdbc连接的数据库是安装另外一台linux的物理机上面，本机测试能通过，但是到虚拟机里的docker环境下就报这个错误，是什么原因？报错信息如下：Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionEx...
could not get jdbc connection oracle,Tomcat连接Oracle时报错：Could not get JDBC Connection;
weixin_29178069的博客
04-03 664
type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exception org.springframework.jdbc.CannotGetJdbcConnectionException: ...
could not get jdbc connection mysql_spring+mybatis整合后could not get JDBC connection的问题
weixin_35626077的博客
01-19 222
首先在网上找了很多方法都没有成功。报错代码如下：org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:### Error querying database. Cause: org.springframework.jdbc.Ca...
could not get jdbc connection mysql_请教ssm框架不能获取JDBC连接的问题Could not get JDBC Connection...
weixin_28829629的博客
02-23 257
使用的是JDK1.7+tomcat7开发的ssm项目，地址栏输入login和register可以正确进入登录和注册页面不报错。在注册页面正确输入完用户名后由ajax提交到UserController进行验证：//注册验证@RequestMapping(value="/checkRegister",method=RequestMethod.POST)publicvoidcheckRegister...
could not get jdbc connection mysql_Could not get JDBC Connection; nested exception is java.sql.SQLE...
weixin_32797441的博客
01-26 1043
在SQL查询进行 group by、order by、distinct、union、多表更新、group_concat、count(distinct)、子查询或表连接的情况下，MySQL 有可能会使用内部临时表。MySQL 首先在内存中创建 Memory 引擎临时表，当临时表的尺寸过大时，会自动转换为磁盘上的 MyISAM 引擎临时表(当查询涉及到 Blob 或 Text 类型字段，MySQL 会...
could not get jdbc connection oracle,jdbc连接oracle时报错 Cause: org.springframework.jdbc.CannotGetJdbcCo...
weixin_28878185的博客
04-03 1597
错误：Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFact...
could not get jdbc connection oracle,centos7 64位系统jdbc连接oracle报错问题
weixin_35664144的博客
04-03 330
这两天发生了一个错误，记录下来。报错如下：### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLRecoverableException: IO Error: Connection res...
Springboot+MySQL，出现Could not get JDBC Connection
12-14
在Spring Boot应用中集成MySQL数据库时，可能会遇到“Could not get JDBC Connection”的错误，这个问题通常是由于数据源配置问题、数据库连接参数错误或者数据库权限问题所导致的。让我们深入了解一下这个问题的...
dbcp 连接池不合理的锁导致连接耗尽解决方案
01-20
DBCP（Database Connection Pool）是Apache的一个开源项目，提供了一个基于Java的数据源连接池实现。在上述问题中，应用程序遇到了由于连接池不合理的锁机制导致的连接耗尽问题，表现为无法从连接池获取新的数据库...
解决 The Network Adapter could not establish the connection
03-20
自己用的解决 "The Network Adapter could not establish the connection" 的连接oracle问题。网上查的一些片段资料。主要是用自己去公司用的。
SQLServer2005JDBC驱动
01-22
SQLServer2005JDBC驱动 需要的朋友下载吧 Could not find class 'javax.naming.StringRefAddr', referenced from method com.mysql.jdbc.ConnectionProperties$ConnectionProperty.storeTo
MyEclipse+hibernate错误：Could not get list of suggested identity strategies from database解决
11-22
总之，解决"MyEclipse+hibernate错误：Could not get list of suggested identity strategies from database"问题需要从数据库连接、Hibernate配置、JDBC驱动等多个方面排查，通过仔细分析错误信息和尝试不同的解决...
Failed to load ApplicationContext
热门推荐
wendy专栏
01-17 3万+
1）现象 java.lang.IllegalStateException: Failed to load ApplicationContext at org.springframework.test.context.CacheAwareContextLoaderDelegate.loadContext(CacheAwareContextLoaderDelegate.java:99) at o
SpringCloud-----Ribbon异常java.net.UnknownHostException
wendy专栏
12-06 6408
1、后台异常内容 org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.web.client.ResourceAccessException: I/O error on GET request for "ht...
Gradle Task的publishToMavenLocal功能报错---Could not find tools.jar
wendy专栏
10-28 3523
只需要右击打开 Open Gradle Run Configuration配置Java Home之后重新Run Gradle Task  
com.mysql.cj.core.exceptions.InvalidConnectionAttributeException: The server time zone value '�й���׼
wendy专栏
04-06 2365
1、异常现场 . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_|...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值