Invalid column name id

最新推荐文章于 2021-08-25 08:59:36 发布
最新推荐文章于 2021-08-25 08:59:36 发布
阅读量763 收藏
点赞数
文章标签： java runtime

org.springframework.jdbc.BadSqlGrammarE xception: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.Nested SQLException: --- The error occurred in ibatisextconf/test.xml. --- The error occurred while applying a result map. --- Check the Customer.CustomerResult. --- Check the result mapping for the 'id' property. --- Cause: java.sql.SQLException: Invalid column name id. at org.springframework.jdbc.support.SQLSta teSQLExceptionTranslator.doTranslate (SQLStateSQLExceptionTranslator.java:97 ) at org.springframework.jdbc.support.Abstra ctFallbackSQLExceptionTranslator.transl ate (AbstractFallbackSQLExceptionTranslator .java:72) at org.springframework.jdbc.support.Abstra ctFallbackSQLExceptionTranslator.transl ate (AbstractFallbackSQLExceptionTranslator .java:80) at org.springframework.jdbc.support.Abstra ctFallbackSQLExceptionTranslator.transl ate (AbstractFallbackSQLExceptionTranslator .java:80) at org.springframework.orm.ibatis.SqlMapCl ientTemplate.execute (SqlMapClientTemplate.java:212) at org.springframework.orm.ibatis.SqlMapCl ientTemplate.queryForObject (SqlMapClientTemplate.java:271) at com.webapp.maintain.customer.dao.Custom erDao.query(CustomerDao.java:50) at com.webapp.maintain.customer.service.Cu stomerService.query (CustomerService.java:23) at sun.reflect.NativeMethodAccessorImpl.in voke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.in voke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImp l.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke (Method.java:597) at org.springframework.aop.support.AopUtil s.invokeJoinpointUsingReflection (AopUtils.java:307) at org.springframework.aop.framework.Refle ctiveMethodInvocation.invokeJoinpoint (ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.Refle ctiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interce ptor.TransactionInterceptor.invoke (TransactionInterceptor.java:106) at org.springframework.aop.framework.Refle ctiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.Exp oseInvocationInterceptor.invoke (ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.Refle ctiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDy namicAopProxy.invoke (JdkDynamicAopProxy.java:204) at $Proxy25.query(Unknown Source) at com.webapp.maintain.customer.action.Cus tomerUpdateAction.query (CustomerUpdateAction.java:17) at com.webapp.struct.module.action.Action. doGet(Action.java:43) at com.webapp.struct.module.action.Empower mentAction.doGet (EmpowermentAction.java:27) at sun.reflect.NativeMethodAccessorImpl.in voke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.in voke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImp l.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke (Method.java:597) at org.springframework.aop.support.AopUtil s.invokeJoinpointUsingReflection (AopUtils.java:307) at org.springframework.aop.framework.Refle ctiveMethodInvocation.invokeJoinpoint (ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.Refle ctiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:149) at org.springframework.aop.aspectj.MethodI nvocationProceedingJoinPoint.proceed (MethodInvocationProceedingJoinPoint.ja va:77) at com.webapp.struct.module.permissions.Pe rmissionsManager.checkQueryPermissions (PermissionsManager.java:71) at sun.reflect.NativeMethodAccessorImpl.in voke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.in voke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImp l.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke (Method.java:597) at org.springframework.aop.aspectj.Abstrac tAspectJAdvice.invokeAdviceMethodWithGi venArgs(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.Abstrac tAspectJAdvice.invokeAdviceMethod (AbstractAspectJAdvice.java:616) at org.springframework.aop.aspectj.AspectJ AroundAdvice.invoke (AspectJAroundAdvice.java:64) at org.springframework.aop.framework.Refle ctiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.Exp oseInvocationInterceptor.invoke (ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.Refle ctiveMethodInvocation.proceed (ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDy namicAopProxy.invoke (JdkDynamicAopProxy.java:204) at $Proxy3.doGet(Unknown Source) at com.webapp.main.WebApp.doGet (WebApp.java:108) at com.webapp.control.action.ActionProcess .execute(ActionProcess.java:24) at com.webapp.main.WebApp.service (WebApp.java:101) at javax.servlet.http.HttpServlet.service (HttpServlet.java:717) at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter (ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFil terChain.doFilter (ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDis patcher.invoke (ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDis patcher.doInclude (ApplicationDispatcher.java:535) at org.apache.catalina.core.ApplicationDis patcher.include (ApplicationDispatcher.java:472) at org.apache.jasper.runtime.JspRuntimeLib rary.include (JspRuntimeLibrary.java:968) at org.apache.jsp.jsp.layout.systemmanage. content_jsp._jspService (content_jsp.java:140) at org.apache.jasper.runtime.HttpJspBase.s ervice(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service (HttpServlet.java:717) at org.apache.jasper.servlet.JspServletWra pper.service (JspServletWrapper.java:374) at org.apache.jasper.servlet.JspServlet.se rviceJspFile(JspServlet.java:342) at org.apache.jasper.servlet.JspServlet.se rvice(JspServlet.java:267) at javax.servlet.http.HttpServlet.service (HttpServlet.java:717) at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter (ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFil terChain.doFilter (ApplicationFilterChain.java:206) at org.apache.catalina.core.ApplicationDis patcher.invoke (ApplicationDispatcher.java:630) at org.apache.catalina.core.ApplicationDis patcher.processRequest (ApplicationDispatcher.java:436) at org.apache.catalina.core.ApplicationDis patcher.doForward (ApplicationDispatcher.java:374) at org.apache.catalina.core.ApplicationDis patcher.forward (ApplicationDispatcher.java:302) at com.webapp.struct.module.mapping.Mappin g.mapping(Mapping.java:25) at com.webapp.control.mapping.MappingProce ss.execute(MappingProcess.java:19) at com.webapp.main.WebApp.service (WebApp.java:101) at javax.servlet.http.HttpServlet.service (HttpServlet.java:717) at org.apache.catalina.core.ApplicationFil terChain.internalDoFilter (ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFil terChain.doFilter (ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrappe rValve.invoke (StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContex tValve.invoke (StandardContextValve.java:191) at org.apache.catalina.core.StandardHostVa lve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportV alve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngine Valve.invoke (StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAda pter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processo r.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol $Http11ConnectionHandler.process (Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$ Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run (Thread.java:619) Caused by: com.ibatis.common.jdbc.exception.Nested SQLException: --- The error occurred in ibatisextconf/test.xml. --- The error occurred while applying a result map. --- Check the Customer.CustomerResult. --- Check the result mapping for the 'id' property. --- Cause: java.sql.SQLException: Invalid column name id. at com.ibatis.sqlmap.engine.mapping.statem ent.MappedStatement.executeQueryWithCal lback(MappedStatement.java:201) at com.ibatis.sqlmap.engine.mapping.statem ent.MappedStatement.executeQueryForObje ct(MappedStatement.java:120) at com.ibatis.sqlmap.engine.impl.SqlMapExe cutorDelegate.queryForObject (SqlMapExecutorDelegate.java:518) at com.ibatis.sqlmap.engine.impl.SqlMapExe cutorDelegate.queryForObject (SqlMapExecutorDelegate.java:493) at com.ibatis.sqlmap.engine.impl.SqlMapSes sionImpl.queryForObject (SqlMapSessionImpl.java:106) at org.springframework.orm.ibatis.SqlMapCl ientTemplate$1.doInSqlMapClient (SqlMapClientTemplate.java:273) at org.springframework.orm.ibatis.SqlMapCl ientTemplate.execute (SqlMapClientTemplate.java:209) ... 79 more Caused by: java.sql.SQLException: Invalid column name id. at net.sourceforge.jtds.jdbc.JtdsResultSet .findColumn(JtdsResultSet.java:976) at net.sourceforge.jtds.jdbc.JtdsResultSet .getInt(JtdsResultSet.java:980) at org.apache.commons.dbcp.DelegatingResul tSet.getInt (DelegatingResultSet.java:237) at sun.reflect.NativeMethodAccessorImpl.in voke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.in voke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImp l.invoke (DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke (Method.java:597) at com.ibatis.common.jdbc.logging.ResultSe tLogProxy.invoke (ResultSetLogProxy.java:47) at $Proxy76.getInt(Unknown Source) at com.ibatis.sqlmap.engine.type.IntegerTy peHandler.getResult (IntegerTypeHandler.java:35) at com.ibatis.sqlmap.engine.mapping.result .ResultMap.getPrimitiveResultMappingVal ue(ResultMap.java:619) at com.ibatis.sqlmap.engine.mapping.result .ResultMap.getResults (ResultMap.java:345) at com.ibatis.sqlmap.engine.execution.SqlE xecutor.handleResults (SqlExecutor.java:384) at com.ibatis.sqlmap.engine.execution.SqlE xecutor.handleMultipleResults (SqlExecutor.java:300) at com.ibatis.sqlmap.engine.execution.SqlE xecutor.executeQuery (SqlExecutor.java:189) at com.ibatis.sqlmap.engine.mapping.statem ent.MappedStatement.sqlExecuteQuery (MappedStatement.java:221) at com.ibatis.sqlmap.engine.mapping.statem ent.MappedStatement.executeQueryWithCal lback(MappedStatement.java:189) ... 85 more

修改内容在sql语句加id

<select id="customerQuery" parameterClass="string" resultMap="CustomerResult"> select id,name,password,age,sex from customer where id=#value# </select>

iteye_1803
关注
Android Caused by: java.lang.IllegalArgumentException: column '_id' does not exist
码莎拉蒂
03-20 3205
出错原因：在查询整个sqlite数据库时，没有查询到 "_id" 这一列。 原来的代码是：mSQLiteDatabase.query(table_name, new String[] {_title}, null, null, null, null, null); 修改后的代码为：mSQLiteDatabase.query(table_name, null, null, null, null,
Python 中 JSONDecodeError: Expecting property name enclosed in double quotes: line 1 column 2
迹忆客
03-20 1241
当我们尝试解析无效的 JSON 字符串（例如，单引号键或值，或尾随逗号）时，会出现 Python“使用方法解决错误。
异常 - Invalid column name 'id'
阿泷的学习日志
08-20 1万+
数据库：SqlServer 描述：数据库字段为大写的ID，查询时使用小写的id。 解决：数据库修改为 CI AS
java 程序升级之mysql Invalid column name 和 思考
草原孤狼的专栏
03-02 2159
对于一般的猿媛来说，升级原来的程序绝对是一件痛苦的事情，而更痛苦的是：除了一个 projcet ，其他什么都没有，就连数据库字段的描述都没有，更不用说是设计文档，数据库设计文档，需求文档等等的。         最近大boss让对一个6年前的项目进行升级，不仅要把程序升级，界面更换，而且还要从sql server 数据库迁移到mysql 上来，可是当拿到项目的那一刻，真是头大。因为除了项目本身，
centos搭建pinpoint及自己踩到的坑
weixin_43831204的博客
09-06 2627
CentOS安装PinPoint，并配置tomcat和springboot应用 1、软件准备 jdk-8u191-linux-x64.tar.gz，下载地址：https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html hbase-1.2.6.1-bin.tar.gz，下载地址：http://archive.apache.org/dist/hbase/ apache-tomcat-9.0.24.tar
db2出现DUAL的错误
琉璃月
03-26 2085
刚学用db2，在做保存操作时出现以下异常: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in bc/tbm/project/model/ProjectDetail...
提示> [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'suppid'. (207)
最新发布
07-08
INSERT INTO cxsybmid (id, departmentmark, departmentname, supdepid, topid) SELECT id, departmentmark, departmentname, supdepid, topid FROM HrmDepartment WHERE supdepid = '71'; ``` 请确保目标表...
Hive SQL报错：SemanticException [Error 10004]: Invalid table alias or column reference
Viga的博客
06-10 1万+
Hive SQL报错：SemanticException [Error 10004]: Invalid table alias or column reference 在python脚本中执行Hive SQL python脚本如下： sql="""SELECT test_url, (case when substring_index(test_url, '/', 1) == 'dev.test.com`:`1024/' then substr(test_url,25) when substring_inde
db2： Invalid parameter: Unknown column name ...ERRORCODE=-4460, SQLSTATE=null
pureboy的专栏
10-10 8328
如标题所述。问题的原因可能是db2驱动引起。原文内容如下： In my case, I got the same error in a similar situation because I had the "wrong" driver jar (db2cc4.jar) in
ibatis中动态查询返回字段返回用resultClass="java.util.HashMap" Java.sql.SQLException: 列名无效的问题
@/"蜗牛
11-08 5080
错误信息： org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in jndi:/localhost/studen/WEB-INF/app-config/query/sqlmap/
Invalid column name ，错误完美解决
热门推荐
IamNotGenius的博客
03-05 5万+
Invalid column name，列名无效。写这篇博客的原因也是之前碰到过这个问题，解决不了，现在又碰到了，死磕了好半天，终于解决，在此记录下。 首先说一下我的背景，就是一个很简单的查询，用的是mapper映射，数据库是oracle。关键部分代码如下： 结果代码执行的时候一直报，Invalid column name 列名错误。映射的字段和数据库比对了N次，都是一致的并没有写错，sq...
Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'user' 附近有语法错误
imhml1987的专栏
09-17 7678
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   --- The error occurred while app
java.sql.SQLException: 列名无效
时间静止
05-23 2万+
在进行jdbc操作时，出现了如下图的bug： 错误原因：在执行sql语句后，进行遍历，但是取值与数据库中的列名不一致。 主要是因为字段名错误，如下，本来应该从数据库中取emp表中的realName字段的数据，却取成了reaName字段的数据，导致出现列名无效的问题 ps：一定要认真！！！ last ps： ...
ODPS2.0语言升级和兼容问题
Janny2015的博客
08-25 1188
问题一：invalid.column.name 在引用一个column时候, LOT模式支持.., 其中这一字段实际会被编译器完全忽略。很多用户可能会在写project_name,但实际上这也是不允许的。原本的编译器没有对该情况报错，实际是个bug。 ODPS2.0将会对此种写法报错。有使用该写法用户将部分去掉即可。 例： select src.a from src; 用户可能不小心写成了 select asdf.src.a from src; 之前能跑过，odps2.0会报错。 问题二：post.sele
hive 三
xwcj3的博客
12-21 751
一、hiveServer2 HiveServer2 = HS2 HS2 ：Server 默认端口号是10000 能不能改成10086呢？ beeline：Client Hive/Spark 启动beeline时，建议先cd $HIVE_HOME/bin中去 ./beeline -u jdbc:hive2://pxj31:10000 -n hadoop nohup bin/hiveserver2 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值