mybatis提示com.microsoft.sqlserver.jdbc.SQLServerException: 列名 'xxxx' 无效。
1、搞了个大乌龙。一直提示列名无效,但是看表是有的啊。原来是SQL的表名写错了,写成了另外一张表
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 | ### Error updating database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 'ip' 无效。 ### The error may exist in file [E:\code\idea_projects\3c\sqlServer\ 01 \quickservice\target\classes\mapper\LoginHistoryEntityMapper.xml] ### The error may involve com.ywservice.dao.login.LoginHistoryEntityMapper.insertLoginHistoryEntity-Inline ### The error occurred while setting parameters ### SQL: insert into T7_DEV_Login_Info ( id, userId, ip, userName, loginDateTime ) values ( ?, ?, ?, ?, ? ) ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 'ip' 无效。 ; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 列名 'ip' 无效。 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java: 239 ) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java: 70 ) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java: 92 ) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java: 439 ) at com.sun.proxy.$Proxy72.insert(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java: 272 ) at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java: 62 ) at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java: 145 ) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java: 86 ) at com.sun.proxy.$Proxy92.insertLoginHistoryEntity(Unknown Source) at com.ywservice.service.login.LoginValidateService.loginValidate(LoginValidateService.java: 113 ) at com.ywservice.controller.login.LoginController.loginValidate(LoginController.java: 26 ) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 62 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 43 ) at java.lang.reflect.Method.invoke(Method.java: 498 ) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java: 205 ) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java: 150 ) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java: 117 ) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java: 895 ) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java: 808 ) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java: 87 ) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java: 1067 ) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java: 963 ) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java: 1006 ) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java: 909 ) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 681 ) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java: 883 ) at javax.servlet.http.HttpServlet.service(HttpServlet.java: 764 ) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 227 ) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 162 ) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java: 53 ) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 189 ) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 162 ) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java: 100 ) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 117 ) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 189 ) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 162 ) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java: 93 ) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 117 ) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 189 ) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 162 ) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java: 201 ) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java: 117 ) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java: 189 ) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java: 162 ) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java: 197 ) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java: 97 ) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java: 541 ) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java: 135 ) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 92 ) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java: 78 ) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 360 ) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java: 399 ) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java: 65 ) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java: 889 ) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java: 1743 ) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java: 49 ) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java: 1191 ) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java: 659 ) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java: 61 ) at java.lang.Thread.run(Thread.java: 748 ) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 'ip' 无效。 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java: 197 ) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java: 1493 ) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java: 390 ) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java: 340 ) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java: 4575 ) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java: 1400 ) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java: 179 ) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java: 154 ) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java: 322 ) at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java: 44 ) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java: 47 ) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java: 74 ) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java: 50 ) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java: 117 ) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java: 76 ) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java: 194 ) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java: 181 ) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 62 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 43 ) at java.lang.reflect.Method.invoke(Method.java: 498 ) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java: 425 ) ... 58 more |
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
2022-01-12 开发思路总结
2022-01-12 开发知识积累
2021-01-12 如何让字符串"000016"转为Integer的16