springmvc+mybatis环境搭建遇到的错误

最新推荐文章于 2022-08-02 16:43:55 发布
最新推荐文章于 2022-08-02 16:43:55 发布
阅读量868 收藏
点赞数 1
分类专栏： 后台开发 mysql spring 解决问题 数据库 文章标签： spring mybatis 环境搭建
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u010697988/article/details/79063010
版权

错误信息如下：

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 create PoolableConnectionFactory (Access denied for user 'xiangzi'@'localhost' (using password: YES))
### The error may exist in file [D:\Workspaces\workspace（new）\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\FirstMP\WEB-INF\classes\com\config\mybatis\mapper\UserInfoMapper.xml]
### The error may involve com.yhr.firstMP.login.dao.UserInfoMapper.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 create PoolableConnectionFactory (Access denied for user 'xiangzi'@'localhost' (using password: YES))
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:948)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)


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 create PoolableConnectionFactory (Access denied for user 'xiangzi'@'localhost' (using password: YES))
### The error may exist in file [D:\Workspaces\workspace（new）\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\FirstMP\WEB-INF\classes\com\config\mybatis\mapper\UserInfoMapper.xml]
### The error may involve com.yhr.firstMP.login.dao.UserInfoMapper.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 create PoolableConnectionFactory (Access denied for user 'xiangzi'@'localhost' (using password: YES))
	org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
	com.sun.proxy.$Proxy12.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy13.selectByPrimaryKey(Unknown Source)
	com.yhr.firstMP.login.controller.LoginController.login(LoginController.java:65)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)


root cause
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 'xiangzi'@'localhost' (using password: YES))
### The error may exist in file [D:\Workspaces\workspace（new）\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\FirstMP\WEB-INF\classes\com\config\mybatis\mapper\UserInfoMapper.xml]
### The error may involve com.yhr.firstMP.login.dao.UserInfoMapper.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 create PoolableConnectionFactory (Access denied for user 'xiangzi'@'localhost' (using password: YES))
	org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)
	com.sun.proxy.$Proxy12.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy13.selectByPrimaryKey(Unknown Source)
	com.yhr.firstMP.login.controller.LoginController.login(LoginController.java:65)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)


root 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 'xiangzi'@'localhost' (using password: YES))
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
	org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:66)
	org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
	org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
	org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
	org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
	org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)
	com.sun.proxy.$Proxy12.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy13.selectByPrimaryKey(Unknown Source)
	com.yhr.firstMP.login.controller.LoginController.login(LoginController.java:65)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)


root cause
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Access denied for user 'xiangzi'@'localhost' (using password: YES))
	org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
	org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
	org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:66)
	org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
	org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
	org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
	org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
	org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)
	com.sun.proxy.$Proxy12.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy13.selectByPrimaryKey(Unknown Source)
	com.yhr.firstMP.login.controller.LoginController.login(LoginController.java:65)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)


root cause
java.sql.SQLException: Access denied for user 'xiangzi'@'localhost' (using password: YES)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:943)
	com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4113)
	com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1308)
	com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2336)
	com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2369)
	com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2153)
	com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
	com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	java.lang.reflect.Constructor.newInstance(Unknown Source)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)
	com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
	org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
	org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
	org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
	org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
	org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
	org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80)
	org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:66)
	org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
	org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
	org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
	org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
	org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:59)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:355)
	com.sun.proxy.$Proxy12.selectOne(Unknown Source)
	org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
	org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:95)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:40)
	com.sun.proxy.$Proxy13.selectByPrimaryKey(Unknown Source)
	com.yhr.firstMP.login.controller.LoginController.login(LoginController.java:65)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:440)
	org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:428)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
解决方法：

1、检查jdbc配置文件的参数值后是否有空格
2、检查mysql中user表中是否有xiangzi这个用户
   首先通过命令行进入mysql：mysql -u root -p，输入密码...
   查看user表中是否有xiangzi用户：
       mysql> use mysql;
       mysql> select user,host from user
    若没有则创建xiangzi用户：
       mysql> CREATE USER 'xiangzi'@'localhost' IDENTIFIED BY '123456';
    创建完成后给xiangzi赋予访问权限
       mysql> grant all privileges on *.* to 'xianzi'@'localhost';
       mysql> flush privileges;


over!

湘梓521
关注
专栏目录
mybatis的环境搭建时出现的错误
qq_44749750的博客
04-20 142
mybatis的环境搭建时出现的错误 第一 问题解决 打开 File ------Prject Structure 然后讲下列各jdk的版本调整为你电脑中的版本 然后再打开 File----setting如下图 这里的jdk版本也必须调整到与你安装的jdk版本一致。 但是，这样并非就成功了，等你下次打开的时候又会让你重新调整 这里一劳永逸的方式是在pom.xml里添加一行代码 <properties> <project.build.sourceEncoding&
mybatis整合springmvc遇到的问题(待解决)
zanghengke的博客
07-31 503
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'itemAction': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.No
Bug0003 org.mybatis.spring.MyBatisSystemException
NoeMan的博客
04-25 174
【报错信息】： org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'XXX' not found. Available parameters are [arg1, arg0, param1, param2] at...
Spring-Mybatis出现数据库报错怎么解决啊？
arispy的博客
06-12 351
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exce
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.taotao.mapper.T
技术黑板
06-13 4434
解决方法： 1、命名空间错误（解决办法：利用对比工具对比MAPPER.XML, POM.XML文件） <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-ma...
mybatis 返回List＜String＞
weixin_43860634的博客
07-12 8848
mybatis
Cause: org.apache.ibatis.plugin.PluginException: Could not find method on interface org.apache.ibati
a214704的博客
01-07 6420
问题具体内容： org.apache.ibatis.exceptions.PersistenceException: ### Error opening session. Cause: org.apache.ibatis.plugin.PluginException: Could not find method on interface org.apache.ibatis.executor....
手把手教你使用VUE+SpringMvc+Spring+Mybatis+Maven构建属于你自己的电商系统之后台前端框架搭建 ——猿实战01
hzldds2019的博客
08-17 1261
手把手教你使用VUE+SpringMvc+Spring+Mybatis+Maven构建属于你自己的电商系统之后台前端框架搭建 ——猿实战01，VUE+SpringMvc+Spring+Mybatis+Maven，电商系统，商城后台，前端框架
SpringMVC+Spring+mybatis+redis项目从零开始--Springmvc配置实现
if(true){ I love it }
10-19 9179
一、SSM项目-Springmvc配置实现 上几章我们简单介绍了SSM项目工程结构、SSM相关配置和集成Redis实现等，本章将实现Springmvc等相关配置，同时通过简单的文件上传、图片上传等实例。 1.     Springmvc简介 Spring Web MVC是一种基于Java的实现了Web MVC设计模式的请求驱动类型的轻量级Web框架，即使用了MVC架构模式的思想，将web层进
基于IDEA搭建SpringMVC+Spring+Mybatis的全过程，并深入了解整个运行流程和项目配置
菜鸟不会飞
09-04 5696
SpringMVC+Spring+Mybatis（SSM）这个组合框架，作为java程序员一定不陌生，SSM作为流行的java web开发框架已经在很多大型公司使用了，在互联网公司实现期间，我用SSM框架比较多，但是也主要是基于已经搭建好的配置环境下，在controller层、service层、mapper层做代码开发工作，对于SSM框架的认知也仅限于知道大概运行流程，以及一些配置文件和注解的作用...
SpringMVC+Mybatis+事务回滚+异常封装返回
跋涉
08-11 7588
问题的背景： 使用dubbo搭建分布式服务架构，service的实现，采用SpringMVC4.1.6+MyBatis3.2.8。为了少维护一个维度，拟对service接口进行通用性定义，即让业务的变化，不影响已定义的service接口。 最终Service的方法签名定义如下（示例）： public ServiceResult addProduct(ServiceParam
Spring+SpringMVC+Mybatis+redislayui做无限级左侧导航。
qq_20056137的博客
06-25 1019
Spring+SpringMVC+Mybatis+redis+layui做无限级左侧导航。    就在上周突然收到一个需求，左侧导航栏要无限级可配置。。。一般左侧导航栏都是三级最多五级很少有需要无限级的，有人可能会问无限级是什么？（再次声明我不卖保健品。。。）无限级导航就是一个无限下级的导航树结构。在这里给大家分享一下我做的demo。温故而知，也方便各位大虾遇到此坑能稳稳跳过。废话不说开始吧。  ...
mybatis调用存储过程报错The error occurred while setting parameters
qw3558089的博客
07-27 4186
最近项目用mybatis调用存储过程，在使用的过程中出现了一个错误：The error may involve com.stockcommission.dao.CommissionMapper.param ### The error occurred while setting parameters ### SQL: {              call VOLUME_TRANSACTION_M...
mysql数据库错误1317_我的mysql数据库好像是连接不上，两天了找不到错误，急求大家的帮助...
weixin_28790465的博客
01-28 995
我的数据库版本是5.7.26，连接驱动时5.1.13，因为找不到5.7.26的驱动，想知道是不是可以不用统一。后面的出现的错误是org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:### Error querying data...
sqlite数据库执行报错--PersistenceException
inexaustible的博客
08-02 4509
sqlite执行修改、插入语句报错
Oracle java.sql.SQLException: 数字溢出
Ethan Mr.的博客
01-15 2895
六月 30, 2016 5:47:47 下午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions 信息: Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql
dataintegrityviolationexception mysql_com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolat...
weixin_31586247的博客
02-23 697
主要是sql语句查询错误，因为查询条件字段pid在两张表中都存在，计算机分不清到底是那张表的查询字段org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationExce...
【已解决】MyBatis查询数据报错 Request processing failed; nested exception is org.mybatis.spring.MyBatisSyst
热门推荐
qq_32106647的博客
01-17 10万+
报错内容org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persi
eclipse 异常Unhandled event loop exception解决办法
比特南柯的专栏
05-23 7万+
新买了台式机，安装eclipse后在打开jar包中的class文件
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值