问题描述:当我在model中添加了一下代码以后数据库报错:

添加的代码为:

private Viewpoint viewpoint;

public Viewpoint getViewpoint() {
return viewpoint;
} public void setViewpoint(Viewpoint viewpoint) {
this.viewpoint = viewpoint;
}

错误信息为:

-- ::56.473 [http-nio--exec-] ERROR [CsrfFilter:] - doFilter
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 'viewpoint' in 'field list'
### The error may exist in com/bim/bdip/cloud/home/mapper/BimWorkflowCollisionMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id_ AS id,viewpoint,guid,workflow_id AS workflowId,zybh,lbbh,yzdjbh,sjzy,zxwz,lcbh,tzhz,th,wtms,yhjy,sjtxgyj,mxyzyj,vp_id AS vpId,vp_picture AS vpPicture,ex_field1 AS exField1,ex_field2 AS exField2,ex_field3 AS exField3,ex_field4 AS exField4,enable_ AS `enable`,remark_ AS remark,create_by AS createBy,create_time AS createTime,update_by AS updateBy,update_time AS updateTime FROM bim_workflow_collision WHERE (workflow_id=?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'viewpoint' in 'field list'
; bad SQL grammar []; nested exception is java.lang.Throwable: Unknown column 'viewpoint' in 'field list'
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:) ~[spring-webmvc-5.0..RC3.jar:5.0..RC3]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:) ~[spring-webmvc-5.0..RC3.jar:5.0..RC3]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:) ~[servlet-api.jar:?]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:) ~[spring-webmvc-5.0..RC3.jar:5.0..RC3]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:) ~[servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:) ~[tomcat-websocket.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:) ~[spring-session-2.0..M2.jar:?]
at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:) ~[spring-session-2.0..M2.jar:?]
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:) ~[spring-web-5.0..RC3.jar:5.0..RC3]
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:) ~[spring-web-5.0..RC3.jar:5.0..RC3]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at com.bim.bdip.cloud.home.core.filter.XssFilter.doFilter(XssFilter.java:) ~[bim-bdip-cloud-home-common-1.1..jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:) ~[catalina.jar:8.5.]
at com.bim.bdip.cloud.home.core.filter.CsrfFilter.doFilter(CsrfFilter.java:) [bim-bdip-cloud-home-common-1.1..jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:) [catalina.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:) [catalina.jar:8.5.]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:) [spring-web-5.0..RC3.jar:5.0..RC3]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:) [spring-web-5.0..RC3.jar:5.0..RC3]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:) [catalina.jar:8.5.]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:) [catalina.jar:8.5.]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:) [catalina.jar:8.5.]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:) [catalina.jar:8.5.]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:) [catalina.jar:8.5.]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:) [catalina.jar:8.5.]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:) [catalina.jar:8.5.]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:) [catalina.jar:8.5.]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:) [catalina.jar:8.5.]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:) [catalina.jar:8.5.]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:) [tomcat-coyote.jar:8.5.]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:) [tomcat-coyote.jar:8.5.]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:) [tomcat-coyote.jar:8.5.]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:) [tomcat-coyote.jar:8.5.]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:) [tomcat-coyote.jar:8.5.]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:) [?:1.8.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:) [?:1.8.0_131]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:) [tomcat-util.jar:8.5.]
at java.lang.Thread.run(Thread.java:) [?:1.8.0_131]
Caused by: org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'viewpoint' in 'field list'
### The error may exist in com/bim/bdip/cloud/home/mapper/BimWorkflowCollisionMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id_ AS id,viewpoint,guid,workflow_id AS workflowId,zybh,lbbh,yzdjbh,sjzy,zxwz,lcbh,tzhz,th,wtms,yhjy,sjtxgyj,mxyzyj,vp_id AS vpId,vp_picture AS vpPicture,ex_field1 AS exField1,ex_field2 AS exField2,ex_field3 AS exField3,ex_field4 AS exField4,enable_ AS `enable`,remark_ AS remark,create_by AS createBy,create_time AS createTime,update_by AS updateBy,update_time AS updateTime FROM bim_workflow_collision WHERE (workflow_id=?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'viewpoint' in 'field list'
; bad SQL grammar []; nested exception is java.lang.Throwable: Unknown column 'viewpoint' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:) ~[spring-jdbc-5.0..RC3.jar:5.0..RC3]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:) ~[spring-jdbc-5.0..RC3.jar:5.0..RC3]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:) ~[mybatis-spring-1.3..jar:1.3.]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:) ~[mybatis-spring-1.3..jar:1.3.]
at com.sun.proxy.$Proxy52.selectList(Unknown Source) ~[?:?]
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:) ~[mybatis-spring-1.3..jar:1.3.]
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:) ~[mybatis-3.4..jar:3.4.]
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:) ~[mybatis-3.4..jar:3.4.]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:) ~[mybatis-3.4..jar:3.4.]
at com.sun.proxy.$Proxy93.selectList(Unknown Source) ~[?:?]
at com.bim.bdip.cloud.home.service.BimWorkflowDetailService.getBimWorkflowInfoById(BimWorkflowDetailService.java:) ~[?:?]
at com.bim.bdip.cloud.home.service.BimWorkflowDetailService$$FastClassBySpringCGLIB$$ad33165e.invoke(<generated>) ~[?:?]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:) ~[spring-core-5.0..RC3.jar:5.0..RC3]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:) ~[spring-aop-5.0..RC3.jar:5.0..RC3]
at com.bim.bdip.cloud.home.service.BimWorkflowDetailService$$EnhancerBySpringCGLIB$$ac4e3918.getBimWorkflowInfoById(<generated>) ~[?:?]
at com.bim.bdip.cloud.home.service.BimWorkflowDetailService$$EnhancerBySpringCGLIB$$ac4e3918MethodAccess.invoke(Unknown Source) ~[?:?]
at com.esotericsoftware.reflectasm.MethodAccess.invoke(MethodAccess.java:) ~[reflectasm-1.09.jar:?]
at com.bim.bdip.cloud.home.core.util.InstanceUtil.invokeMethod(InstanceUtil.java:) ~[bim-bdip-cloud-home-common-1.1..jar:?]
at com.bim.bdip.cloud.home.core.base.BaseProviderImpl.execute(BaseProviderImpl.java:) ~[bim-bdip-cloud-home-common-1.1..jar:?]
at sun.reflect.GeneratedMethodAccessor141.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:) ~[?:1.8.0_131]
at java.lang.reflect.Method.invoke(Method.java:) ~[?:1.8.0_131]
at com.weibo.api.motan.rpc.DefaultProvider.invoke(DefaultProvider.java:) ~[motan-core-0.3..jar:?]
at com.weibo.api.motan.rpc.AbstractProvider.call(AbstractProvider.java:) ~[motan-core-0.3..jar:?]
at com.weibo.api.motan.transport.ProviderMessageRouter.call(ProviderMessageRouter.java:) ~[motan-core-0.3..jar:?]
at com.weibo.api.motan.transport.ProviderProtectedMessageRouter.call(ProviderProtectedMessageRouter.java:) ~[motan-core-0.3..jar:?]
at com.weibo.api.motan.transport.ProviderMessageRouter.handle(ProviderMessageRouter.java:) ~[motan-core-0.3..jar:?]
at com.weibo.api.motan.transport.support.DefaultRpcHeartbeatFactory$HeartMessageHandleWrapper.handle(DefaultRpcHeartbeatFactory.java:) ~[motan-core-0.3..jar:?]
at com.weibo.api.motan.transport.netty.NettyChannelHandler.processRequest(NettyChannelHandler.java:) ~[motan-transport-netty-0.3..jar:?]
at com.weibo.api.motan.transport.netty.NettyChannelHandler.access$(NettyChannelHandler.java:) ~[motan-transport-netty-0.3..jar:?]
at com.weibo.api.motan.transport.netty.NettyChannelHandler$.run(NettyChannelHandler.java:) ~[motan-transport-netty-0.3..jar:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:) ~[?:1.8.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:) ~[?:1.8.0_131]
... more
Caused by: java.lang.Throwable: Unknown column 'viewpoint' in 'field list'

原因是mybatis查询以后在数据库找不到这个字段,所以报错了。

解决:

在private ViewPoint viewpoint;加上@TableField(exist = false)这个注解就可以了

@TableField(exist = false)
private Viewpoint viewpoint; public Viewpoint getViewpoint() {
return viewpoint;
} public void setViewpoint(Viewpoint viewpoint) {
this.viewpoint = viewpoint;
}

最新文章

  1. java进阶之反射:反射基础之如何获取一个类以及如何获取这个类的所有属性和方法(2)
  2. [转]Asp.Net 用户验证(自定义IPrincipal和IIdentity)
  3. 详解Javascript的继承实现(二)
  4. 一步一步学习.NET Core 介绍篇 01
  5. libevent之丢失header问题
  6. Hibernate 配置文件与映射文件 总结
  7. [译]git reflog
  8. U3D使anim,unity,prefab文件不显示乱码
  9. uva 558 tree(不忍吐槽的题目名)——yhx
  10. JavaWeb学习----http协议
  11. vimrc配置文件_version1.0_+pathogen, taglist, wordcomplete插件说明
  12. Div高度百分比
  13. Nasty Hacks &lt;入门练手题&gt;
  14. linux 两个查找工具 locate,find详解
  15. 让anujs支持rc-select
  16. 基于ajax 验证表单是否被占用----------------附:10.25日总结
  17. Android 开发 框架系列 EventBus 事件总线
  18. c#调用带输出参数的存储过程
  19. zabbix监控系列(5)之通过trap模式监控网络设备
  20. web前端----css属性

热门文章

  1. jsp笔记3(内置对象)
  2. iOS isa 浅析
  3. Android入门之文件系统操作
  4. android 代码覆盖率
  5. SQL SERVER 2012 尝试读取或写入受保护的内存。这通常指示其他内存已损坏。 (System.Data)
  6. javascript 对象属性的添加,删除,json对象和字符串转换方法等
  7. top显示的内存各项参数解析
  8. django 用model来简化form
  9. 项目笔记:导出XML和导出全部XML功能
  10. 移动web之响应式布局