Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException

最新推荐文章于 2024-07-06 15:28:27 发布
最新推荐文章于 2024-07-06 15:28:27 发布
阅读量1.2w 收藏 1
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/m0_38143169/article/details/70578068
版权

今天在做一个跳转的时候总是报错，未定义字段，检查过数据库没有问题，最后没办法，又重新检查了一遍代码，才发现是连接数据库连接错了，看来还是要仔细一点


HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

type Exception report

message Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:

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.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
### The error may exist in com/hyc/dao/ManagerMapper.xml
### The error may involve com.hyc.dao.ManagerMapper.selectByNameAndPassword-Inline
### The error occurred while setting parameters
### SQL: select     *     from manager     where m_name=? and m_password=?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
### The error may exist in com/hyc/dao/ManagerMapper.xml
### The error may involve com.hyc.dao.ManagerMapper.selectByNameAndPassword-Inline
### The error occurred while setting parameters
### SQL: select     *     from manager     where m_name=? and m_password=?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
	org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
	com.sun.proxy.$Proxy11.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.$Proxy12.selectByNameAndPassword(Unknown Source)
	com.hyc.service.impl.ManagerServiceImpl.selectByNameAndPassword(ManagerServiceImpl.java:21)
	com.hyc.action.ManagerAction.login(ManagerAction.java:28)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:111)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

root cause

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'm_name' in 'where clause'
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
	com.mysql.jdbc.Util.getInstance(Util.java:360)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
	com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199)
	org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)
	com.sun.proxy.$Proxy22.execute(Unknown Source)
	org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:59)
	org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:73)
	org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:60)
	org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
	org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:137)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96)
	org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:108)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:102)
	org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:66)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
	com.sun.proxy.$Proxy11.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.$Proxy12.selectByNameAndPassword(Unknown Source)
	com.hyc.service.impl.ManagerServiceImpl.selectByNameAndPassword(ManagerServiceImpl.java:21)
	com.hyc.action.ManagerAction.login(ManagerAction.java:28)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:111)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:806)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:729)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.42 logs.

小何，加油
关注
Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarException
Eros_1的博客
07-24 1172
今天做分页查询数据库中的信息时，当查询数据库中不存在的数据时，页面就会报错，最终发现是分页时的问题，当查询到当查询到的数据为0时，总页数是0，当前页数据的起始就是-5，去数据库中查询就会报错，当查询数据为0时将总页数设置为1就可以解决错误。 HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed; nested exception is org.springframewor
idea报错-- Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarExcep
alovelypeach的博客
07-28 2393
HTTP Status 500 – Internal Server Error Type 异常报告 消息 Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 描述 服务器遇到一个意外的情况，阻止它完成请求。 Exception org.springframework.web.util.NestedServletException: Request processing.
org.springframework.jdbc.BadSqlGrammarException异常
最新发布
m0_73939789的博客
07-06 819
在执行定时任务更新电子书统计信息时，遇到了异常，具体表现为 SQL 函数count被错误地解析为自定义函数wiki.count，导致数据库更新操作失败。
HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGram
xmt1139057136的专栏
03-20 7938
HTTP Status 有很多，其中最常见的应该是 500 错误了。 这篇文章我就给大家分享一下，HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGram 的解决办法！ HTTP Status 500 - Request processing f...
错误提示：Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarException:
热门推荐
qq_51515673的博客
04-12 4万+
错误提示： 类型 异常报告 消息 Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 描述 服务器遇到一个意外的情况，阻止它完成请求。 解决方案： 检查dao层xxxMapper.xml文件中的SQL语句是否有语法错误，特别是中英文标点问题 检查数据库的字段名是否和项目中的配置的设置的字段名（dao层xxxMapper.xml文件中的SQL语句字段名）.
dataintegrityviolationexception mysql_com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolat...
weixin_31586247的博客
02-23 699
主要是sql语句查询错误，因为查询条件字段pid在两张表中都存在，计算机分不清到底是那张表的查询字段org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationExce...
错误之Request processing failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefini...
weixin_34221773的博客
09-26 2128
HTTP Status 500 - Request processing failed; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'transactionManager' is defined type Exception report...
Request processing failed; nested exception is org.springframework.transaction.
luguangrui_520_123的博客
04-13 4675
Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLExcepti...
Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exc
Lele
03-06 2万+
HTTP Status 500 – Internal Server Error Type Exception Report Message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.i...
消息：Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested
Z2Min_
05-10 5544
HTTP Status 500 – Internal Server Error Type 异常报告 消息 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 描述 服务器遇到一个意外的情况，阻止它完成请求。 Exception org.spr
报错记录：Request processing failed； nested exception is org.springframework.jdbc.BadSqlGrammarException:
qq_53344479的博客
02-27 1148
这是我的报错 原因： 数据库的sql语句出现了问题，仔细检查该功能的语句。set后面多了一个等号 <update id="updateBook" parameterType="Books"> update ssmbuild.books set = bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail} where bookID=#{bookID}; </
nested exception is org.apache.ibatis.reflection.ReflectionException
qq_39736176的博客
09-30 3万+
错误情况 Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: Could not set property 'paperId' o...
Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException:
菜鸟腾飞
11-20 1万+
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: com.mysql.jdb
HTTP Status 500 - Request processing failed； nested exception is org.springframework.jdbc.BadSqlGram
不撸先疯。
09-06 6948
一、问题描述 在编写spring和spring-MVC框架的时候，出现问题： HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: type Exception report message Request processing failed; nested exception is org.springframework.jdbc
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值