Java系列：Cannot load JDBC driver class 'com.mysql.jdbc.Driver '

最新推荐文章于 2024-01-26 13:50:17 发布

原创

最新推荐文章于 2024-01-26 13:50:17 发布 · 置顶 · 8.8k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Eclipse #jdbc

在整合springmvc+spring+mybatis的过程中遭遇HTTP Status 500错误，具体表现为无法加载JDBC驱动类'com.mysql.jdbc.Driver'。此问题涉及到MyBatis和Apache Tomcat的配置及异常堆栈分析。

今天在搭建springmvc+spring+mybatis时遇到下面这个错误，感觉很诡异。

后来才发现是因为我通过网页复制粘贴代码时'com.mysql.jdbc.Driver '后面多了空格。

HTTP Status 500 - Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

type Exception report

message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is 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:\dev\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\springmvc-spring-mybatis-demo\WEB-INF\classes\com\alibaba\ssm\demo\mapping\UserMapping.xml]
### The error may involve com.alibaba.ssm.demo.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  '
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:973)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)

root cause

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:\dev\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\springmvc-spring-mybatis-demo\WEB-INF\classes\com\alibaba\ssm\demo\mapping\UserMapping.xml]
### The error may involve com.alibaba.ssm.demo.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  '
	org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
	com.sun.proxy.$Proxy13.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:163)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
	com.sun.proxy.$Proxy14.selectByPrimaryKey(Unknown Source)
	com.alibaba.ssm.demo.service.impl.UserServiceImpl.getUserById(UserServiceImpl.java:18)
	com.alibaba.ssm.demo.controller.UserController.toIndex(UserController.java:23)
	sun.reflect.N

最低0.47元/天解锁文章

新学期VIP享超值加赠