ibatis java.sql.SQLException:列名无效

最新推荐文章于 2024-06-21 11:02:51 发布
转载 最新推荐文章于 2024-06-21 11:02:51 发布 · 4.7k 阅读 · 0

博主在使用ibatis框架时遇到列名无效的SQLException异常。通过社区讨论发现，问题出现在resultMap中column属性配置不当，最终移除表名后解决了问题。

 ibatis java.sql.SQLException:列名无效 [问题点数：40分，结帖人toss3000]

  •            
  •            
  •            
  •            
  •            
  •            收藏
    • 楼主 发表于： 2011-11-08 17:32:12
    这是我的配置文件

    <sqlMap>
    <typeAlias alias="erpSales" type="com.richfit.bi.imap.business.ErpSalesRelation"/>
    <resultMap id="erpSaleRef" class="erpSales">  
             <result property="id" column="ID"/>  
             <result property="areaId" column="AREAID"/>
             <result property="typeId" column="TYPEID"/>  
             <result property="income" column="INCOME"/>
             <result property="typeName" column="ERP_SALES_TYPE.TYPENAME"/>
             <result property="areaName" column="ERP_SALES_AREA.AREANAME"/>  
        </resultMap>  
        
    <!-- 获得销售对象-->
     <select id="querySpecErpSales" parameterClass="string" resultMap="erpSaleRef" >
    <![CDATA[
    SELECT rel.Id,rel.AREAID,rel.TYPEID,rel.INCOME,type.TYPENAME,area.AREANAME 
    FROM ERP_SALES_RELATION rel,ERP_SALES_TYPE type,ERP_SALES_AREA area 
    WHERE area.AREANAME=#areaName# and area.AREAID=rel.AREAID and rel.TYPEID= type.TYPEID
    ]]>
    </select>


    </sqlMap>

    这是我的ErpSalesRelation类
    public class ErpSalesRelation
    {
    private int id;
    private int typeId;
    private int areaId;
    private String typeName;
    private String areaName;
    private String income;

    -----省略set/get方法

    这是我的数据表
    create table ERP_SALES_AREA
    (
      AREAID   NUMBER(20) not null,
      AREANAME VARCHAR2(14)
    )

    create table ERP_SALES_TYPE
    (
      TYPEID   NUMBER(20) not null,
      TYPENAME VARCHAR2(14)
    )

    create table ERP_SALES_RELATION
    (
      ID     NUMBER(20) not null,
      AREAID NUMBER(20) not null,
      TYPEID NUMBER(20) not null,
      INCOME VARCHAR2(20)
    )

    运行后报异常:
    java.sql.SQLException: 列名无效

    请高手指点到底拿错了.....!!!!
    width="728" height="90" frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" id="aswift_1" name="aswift_1" style="box-sizing: content-box; left: 0px; position: absolute; top: 0px;">
    • id="iframeu1636200_0" src="http://pos.baidu.com/rckm?rdid=1636200&dc=2&di=u1636200&dri=0&dis=0&dai=3&ps=2182x408&dcb=BAIDU_SSP_define&dtm=HTML_POST&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1473296059518&ti=ibatis%20java.sql.SQLException%3A%20%E5%88%97%E5%90%8D%E6%97%A0%E6%95%88-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF&ari=2&dbv=2&drs=3&pcs=1395x786&pss=1395x6467&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1473296059&rw=786&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F380037274&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DKElWaMhLKYMGCeOvilVEQFoyE4qMVPWUwYKWCaSYv1puoGcABVInb6aAZbHhw4yl%26wd%3D%26eqid%3Dca61898e000618b70000000557d0b6b7&ecd=1&psr=1920x1080&par=1920x1040&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1473296060&qn=ff9e4363d3b4ace7&tt=1473296059493.466.589.589" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
       
    • id="iframeu1636201_0" src="http://pos.baidu.com/rckm?rdid=1636201&dc=2&di=u1636201&dri=0&dis=0&dai=4&ps=2182x662&dcb=BAIDU_SSP_define&dtm=HTML_POST&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1473296059518&ti=ibatis%20java.sql.SQLException%3A%20%E5%88%97%E5%90%8D%E6%97%A0%E6%95%88-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF&ari=2&dbv=2&drs=3&pcs=1395x786&pss=1395x6467&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1473296059&rw=786&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F380037274&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DKElWaMhLKYMGCeOvilVEQFoyE4qMVPWUwYKWCaSYv1puoGcABVInb6aAZbHhw4yl%26wd%3D%26eqid%3Dca61898e000618b70000000557d0b6b7&ecd=1&psr=1920x1080&par=1920x1040&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1473296060&qn=74e2ac9d7a317eec&tt=1473296059493.467.592.593" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
       
    • id="iframeu1636204_0" src="http://pos.baidu.com/rckm?rdid=1636204&dc=2&di=u1636204&dri=0&dis=0&dai=5&ps=2182x916&dcb=BAIDU_SSP_define&dtm=HTML_POST&dvi=0.0&dci=-1&dpt=none&tsr=0&tpr=1473296059518&ti=ibatis%20java.sql.SQLException%3A%20%E5%88%97%E5%90%8D%E6%97%A0%E6%95%88-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF&ari=2&dbv=2&drs=3&pcs=1395x786&pss=1395x6467&cfv=0&cpl=4&chi=1&cce=true&cec=UTF-8&tlm=1473296059&rw=786&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F380037274&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DKElWaMhLKYMGCeOvilVEQFoyE4qMVPWUwYKWCaSYv1puoGcABVInb6aAZbHhw4yl%26wd%3D%26eqid%3Dca61898e000618b70000000557d0b6b7&ecd=1&psr=1920x1080&par=1920x1040&pis=-1x-1&ccd=24&cja=false&cmi=6&col=zh-CN&cdo=-1&tcn=1473296060&qn=37d69ffb9faacabb&tt=1473296059493.469.652.653" width="200" height="22" align="center,center" vspace="0" hspace="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0" allowtransparency="true" style="box-sizing: content-box; border-width: 0px; border-style: initial; vertical-align: bottom; margin: 0px;">
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      回复次数：13
      #1 得分：0 回复于： 2011-11-08 17:42:05
      是LZ哪个数据库字段写错了吧，把CDATA里面的放到SQL里面执行下
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #2 得分：0 回复于： 2011-11-08 17:59:42
      既然提示列名无效，肯定是字段名有不正确的地方，仔细查下。
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #3 得分：0 回复于： 2011-11-08 18:43:06
      <resultMap id="erpSaleRef" class="erpSales">   
        <result property="id" column="ID"/>   
        <result property="areaId" column="AREAID"/>
        <result property="typeId" column="TYPEID"/>   
        <result property="income" column="INCOME"/>
        
        <result property="typeName" column="typeName" select="ERP_SALES_TYPE.TYPENAME"/>
        <result property="areaName" column="areaName" select="ERP_SALES_AREA.AREANAME"/>         
      </resultMap>  
      试下这种行不？
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #4 得分：0 回复于： 2011-11-08 20:22:29
      Id是保留字吗
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #5 得分：0 回复于： 2011-11-09 08:50:15
      谢谢大家关注，to lyhmy，试了你的方法，不行还是......,to xiaoqiuwyh,我的sql是可以执行的......,这个方法是通过网上的ibatis指南写的,google一下午也没搞明白错误出在哪里
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #6 得分：0 回复于： 2011-11-09 09:50:24
      <result property="typeId" column="TYPEID"/>  
      用表名加列名试试
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #7 得分：0 回复于： 2011-11-09 10:10:51
      用表名加列名试试,haha
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #8 得分：0 回复于： 2011-11-09 10:43:52
      shupo,我用的就是表名加列名了
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #9 得分：30 回复于： 2011-11-09 10:53:57
      <result property="typeName" column="ERP_SALES_TYPE.TYPENAME"/>
      <result property="areaName" column="ERP_SALES_AREA.AREANAME"/> 

      去掉表名试下，我刚刚在DB2上，用表名加列名就会报错
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #10 得分：0 回复于： 2011-11-09 11:24:44
      引用 9 楼 zyz1985 的回复:
      <result property="typeName" column="ERP_SALES_TYPE.TYPENAME"/>
      <result property="areaName" column="ERP_SALES_AREA.AREANAME"/> 

      去掉表名试下，我刚刚在DB2上，用表名加列名就会报错


      3ks zyz1985 ，可以运行了！！！！！！！！！怎么会这样啊，为什么呢？
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #11 得分：10 回复于： 2011-11-09 14:58:21
      估计是你<resultMap id="erpSaleRef" class="erpSales"> ，对应的是ErpSalesRelation类，而ErpSalesRelation类中的属性就直接是typeName、areaName，到时传值因在ErpSalesRelation类中有set\get，可以直接获值； 而非对象ERP_SALES_TYPE、ERP_SALES_AREA的属性，所以不需要加上具体的类名（对应的是表字段）

      引用 10 楼 toss3000 的回复:
      引用 9 楼 zyz1985 的回复:

      <result property="typeName" column="ERP_SALES_TYPE.TYPENAME"/>
      <result property="areaName" column="ERP_SALES_AREA.AREANAME"/>

      去掉表名试下，我刚刚在DB2上，用表名加列名就会报错


      3ks zyz1985 ，可以……
      对我有用[0]  丢个板砖[0]  引用 |  举报 |  管理
      #13 得分：0 回复于： 2011-11-09 15:24:38
      引用 11 楼 lyhmy 的回复:
      估计是你<resultMap id="erpSaleRef" class="erpSales"> ，对应的是ErpSalesRelation类，而ErpSalesRelation类中的属性就直接是typeName、areaName，到时传值因在ErpSalesRelation类中有set\get，可以直接获值； 而非对象ERP_SALES_TYPE、ERP_SALES_AREA的属性，所以不需要……


      分析的我感觉有道理，这种写法我是参照ibatis开发指南写的，看来真是尽信书不如无书啊
      解决bad SQL grammar []； nested exception is java.sql.SQLSyntaxErrorException
      m0_74823336的博客
      12-09 2258
      确保底层SQL与上层调用的代码都没有逻辑问题，所以“bad SQL grammar []”应该是由配置文件导致的，检查项目的。这种配置的使用对于一些特殊的SQL语句执行场景非常有帮助，但需要谨慎使用，确保SQL语句的合法性和安全性。在使用Spring Boot连接MySQL数据库时，有时候会遇到“Bad SQL Grammar”错误，这种错误通常在执行SQL语句时发生。本文针对的是对于执行多条SQL语句的情况。MySQL连接配置中有一些常用的参数，这些参数可以在数据库连接字符串（URL）中进行配置。
      java.sql.SQLException: 无效的列索引
      忆北——回忆再美好也回不去
      09-13 3091
      “java.sql.SQLException: 无效的列索引”，其实是个低级的错误，原因无非几个：   1、sql串的?号数目和提供的变量数目不一致： 例如：jdbcTemplate.update(sql, new Object[] {newState,oldState}); 如果sql里面有1个?号，Object[]送了2个，就会报错。   2、sql串里的?号书写不正确 英文?和
      SQL Server2008 列名显示无效
      bigheadsheep的专栏
      08-16 4万+
      在SQLServer2008中，当设计（修改）表结构之后，再用SQL语句时，列名会显示无效，但执行可以通过 如下图：   原因是SQL Server的intellisense（智能感知功能）需要重新整理一下，用快捷键Ctrl+Shift+R即可   关于intellisense（智能感知功能）的主要功能，就是在用户具有权限的前提下， 在Query Editior中输入架构并加上".
      SQL显示列名无效
      qq_46994975的博客
      06-21 3618
      错误消息 "列名无效" 通常指的是在SQL查询或数据库操作中使用了数据库表中不存在的列名。在实际应用中，解决 "列名无效" 的问题需要对数据库结构有深入了解，并确保查询与数据库结构保持一致。：如果表结构已经变更，比如删除了某个列，但是查询没有相应地更新，就会出现这个错误。：在多表查询中，确保为涉及的表指定了正确的别名，并在查询中使用这些别名。：可能在错误的表中引用了列名，或者在多表查询中没有正确指定表别名。：在使用数据库视图时，如果视图中没有包含该列，也会导致这个错误。：确保查询中使用的列名拼写正确。
      列名无效
      weixin_30896511的博客
      07-09 202
      数据库增加新，视图没有更新 转载于:https://www.cnblogs.com/Neil-Peng/p/9283355.html
      2025-09-17 09:45:04 [ ERROR ] 处理任务异常>........[AOIAlarmTask]!nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=&#39;toTime&#39;, mode=IN, javaType=class java.lang.Object, jdbcType=TIMESTAMP, numericScale=null, resultMapId=&#39;null&#39;, jdbcTypeName=&#39;null&#39;, expression=&#39;null&#39;}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #4 with JdbcType TIMESTAMP . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #4 with JdbcType TIMESTAMP . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: 无效的列索引
      09-18
      SQL 语句中存在语法错误，如函数调用错误、列名拼写错误等，会导致数据库解析 SQL 时无法正确识别列，从而引发无效列索引问题。例如，`SUBSTR` 函数使用时参数缺失或格式错误，像 `SUBSTR(D.PROD_ID), 1, 3)` 应修正...
      nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=&#39;alarmRequest.batch_id&#39;, mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId=&#39;null&#39;, jdbcTypeName=&#39;null&#39;, expression=&#39;null&#39;}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: 无效的列索引] with root cause java.sql.SQLException: 无效的列索引
      07-14
      这个错误通常是由于在查询语句中使用了一个无效的列名或索引导致的。请检查您的查询语句，确保使用的列名或索引是正确的。 另外，还有可能是由于参数映射的问题导致的。您可以检查一下参数映射的配置，确保参数类型...
      nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=&#39;__frch_t_12.returncontext&#39;, mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=&#39;null&#39;, jdbcTypeName=&#39;null&#39;, expression=&#39;null&#39;}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #128 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111
      06-24
      - **解决方法**：检查 SQL 语句中的列名和数据类型是否正确。例如，确保表结构与插入语句匹配： ```sql CREATE TABLE PERSON ( ID INT PRIMARY KEY, NAME VARCHAR(255), AGE INT ); ``` - **原因 3**：MyBatis ...
      Error setting non null for parameter #5 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #5 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: 无效的列类型
      05-24
      这个错误通常是因为 MyBatis 在执行 SQL 语句时无法将 Java 对象转换为对应的数据库类型。你可以尝试以下几种方法解决这个问题： 1. 检查数据库中的表结构是否与 MyBatis 映射文件中的配置一致，包括数据类型、列名...
      2025-09-29 16:32:04.029 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [0d852c52, L:/192.168.10.130:9002 - R:/192.168.10.130:45061] Increasing pending responses, now 1 2025-09-29 16:32:04.030 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServer - [0d852c52-3, L:/192.168.10.130:9002 - R:/192.168.10.130:45061] Handler is being applied: org.springframework.http.server.reactive.ReactorHttpHandlerAdapter@bc9fa7 2025-09-29 16:32:04.030 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [0d852c52-5] HTTP POST "/asn/main/update/cancel/release/status/1?id=1" 2025-09-29 16:32:04.030 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerMapping - [0d852c52-5] Mapped to com.hvlink.controller.AsnMainController#updateCancelReleaseStatus(Integer) 2025-09-29 16:32:04.031 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Creating new transaction with name [com.hvlink.service.impl.AsnMainServiceImpl.updateCancelReleaseStatus]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,-java.lang.Exception 2025-09-29 16:32:04.031 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Acquired Connection [ConnectionID:1 ClientConnectionId: 02394c45-fc74-423f-9900-14b0b8ed10c1] for JDBC transaction 2025-09-29 16:32:04.031 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Switching JDBC Connection [ConnectionID:1 ClientConnectionId: 02394c45-fc74-423f-9900-14b0b8ed10c1] to manual commit 2025-09-29 16:32:04.040 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession 2025-09-29 16:32:04.040 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d5b3b56] 2025-09-29 16:32:04.041 [reactor-http-nio-2] DEBUG o.m.spring.transaction.SpringManagedTransaction - JDBC Connection [ConnectionID:1 ClientConnectionId: 02394c45-fc74-423f-9900-14b0b8ed10c1] will be managed by Spring 2025-09-29 16:32:04.041 [reactor-http-nio-2] DEBUG com.hvlink.mapper.asn.AsnMainMapper.selectList - ==> Preparing: SELECT id,company_code,factory_code,warehouse_code,shipper_id,asn_no,status,production_batch,shipping_date,estimated_arrival_date,estimated_consumption_time,is_first_product,is_fully_shipping,release_date,is_deleted,create_by,create_time,update_by,update_time FROM tb_asn_main WHERE (id = ?) 2025-09-29 16:32:04.041 [reactor-http-nio-2] DEBUG com.hvlink.mapper.asn.AsnMainMapper.selectList - ==> Parameters: 1(Integer) 2025-09-29 16:32:04.057 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d5b3b56] 2025-09-29 16:32:04.057 [reactor-http-nio-2] DEBUG o.s.j.support.SQLErrorCodeSQLExceptionTranslator - Translating SQLException with SQL state &#39;S0001&#39;, error code &#39;207&#39;, message [列名 &#39;create_by&#39; 无效。] for task [ ### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 ### The error may exist in com/hvlink/mapper/asn/AsnMainMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,company_code,factory_code,warehouse_code,shipper_id,asn_no,status,production_batch,shipping_date,estimated_arrival_date,estimated_consumption_time,is_first_product,is_fully_shipping,release_date,is_deleted,create_by,create_time,update_by,update_time FROM tb_asn_main WHERE (id = ?) ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 ] 2025-09-29 16:32:04.057 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d5b3b56] 2025-09-29 16:32:04.057 [reactor-http-nio-2] DEBUG org.mybatis.spring.SqlSessionUtils - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@1d5b3b56] 2025-09-29 16:32:04.057 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Initiating transaction rollback 2025-09-29 16:32:04.057 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Rolling back JDBC transaction on Connection [ConnectionID:1 ClientConnectionId: 02394c45-fc74-423f-9900-14b0b8ed10c1] 2025-09-29 16:32:04.096 [reactor-http-nio-2] DEBUG o.s.jdbc.datasource.DataSourceTransactionManager - Releasing JDBC Connection [ConnectionID:1 ClientConnectionId: 02394c45-fc74-423f-9900-14b0b8ed10c1] after transaction 2025-09-29 16:32:04.097 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.a.RequestMappingHandlerAdapter - [0d852c52-5] Using @ExceptionHandler com.hvlink.exceptions.ExceptionHandle#handleException(Exception) 2025-09-29 16:32:04.099 [reactor-http-nio-2] ERROR com.hvlink.exceptions.ExceptionHandle - ===服务器内部错误== org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 ### The error may exist in com/hvlink/mapper/asn/AsnMainMapper.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,company_code,factory_code,warehouse_code,shipper_id,asn_no,status,production_batch,shipping_date,estimated_arrival_date,estimated_consumption_time,is_first_product,is_fully_shipping,release_date,is_deleted,create_by,create_time,update_by,update_time FROM tb_asn_main WHERE (id = ?) ### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 ; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:236) Suppressed: reactor.core.publisher.FluxOnAssembly$OnAssemblyException: Assembly trace from producer [reactor.core.publisher.MonoFlatMap] : reactor.core.publisher.Mono.flatMap(Mono.java:3137) org.springframework.web.reactive.result.method.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:136) Error has been observed at the following site(s): *___Mono.flatMap ⇢ at org.springframework.web.reactive.result.method.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:136) *_____Mono.defer ⇢ at org.springframework.web.reactive.result.method.annotation.RequestMappingHandlerAdapter.handle(RequestMappingHandlerAdapter.java:200) *______Mono.then ⇢ at org.springframework.web.reactive.result.method.annotation.RequestMappingHandlerAdapter.handle(RequestMappingHandlerAdapter.java:200) |_ Mono.doOnNext ⇢ at org.springframework.web.reactive.result.method.annotation.RequestMappingHandlerAdapter.handle(RequestMappingHandlerAdapter.java:201) |_ Mono.doOnNext ⇢ at org.springframework.web.reactive.result.method.annotation.RequestMappingHandlerAdapter.handle(RequestMappingHandlerAdapter.java:202) Original Stack Trace: at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:236) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy116.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy121.selectList(Unknown Source) at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectOne(BaseMapper.java:172) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy121.selectOne(Unknown Source) at com.hvlink.service.impl.AsnMainServiceImpl.updateCancelReleaseStatus(AsnMainServiceImpl.java:822) at com.hvlink.service.impl.AsnMainServiceImpl$$FastClassBySpringCGLIB$$906a1c7c.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at com.hvlink.service.impl.AsnMainServiceImpl$$EnhancerBySpringCGLIB$$70692874.updateCancelReleaseStatus(<generated>) at com.hvlink.controller.AsnMainController.updateCancelReleaseStatus(AsnMainController.java:83) 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.reactive.result.method.InvocableHandlerMethod.lambda$invoke$0(InvocableHandlerMethod.java:145) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:125) at reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1839) at reactor.core.publisher.MonoZip$ZipCoordinator.signal(MonoZip.java:258) at reactor.core.publisher.MonoZip$ZipInner.onNext(MonoZip.java:347) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180) at reactor.core.publisher.FluxDefaultIfEmpty$DefaultIfEmptySubscriber.onNext(FluxDefaultIfEmpty.java:101) at reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:74) at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2400) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2196) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onSubscribe(Operators.java:2070) at reactor.core.publisher.FluxFlatMap.trySubscribeScalarMap(FluxFlatMap.java:192) at reactor.core.publisher.MonoFlatMap.subscribeOrReturn(MonoFlatMap.java:53) at reactor.core.publisher.Mono.subscribe(Mono.java:4475) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:129) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:240) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onComplete(MonoIgnoreThen.java:203) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onComplete(MonoFlatMap.java:181) at reactor.core.publisher.Operators.complete(Operators.java:137) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:121) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:157) at reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:74) at reactor.core.publisher.MonoNext$NextSubscriber.onNext(MonoNext.java:82) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.innerNext(FluxConcatMap.java:282) at reactor.core.publisher.FluxConcatMap$ConcatMapInner.onNext(FluxConcatMap.java:863) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:129) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180) at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2400) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.request(MonoPeekTerminal.java:139) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2196) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onSubscribe(Operators.java:2070) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onSubscribe(FluxMapFuseable.java:96) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onSubscribe(MonoPeekTerminal.java:152) at reactor.core.publisher.MonoJust.subscribe(MonoJust.java:55) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.drain(FluxConcatMap.java:451) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.onSubscribe(FluxConcatMap.java:219) at reactor.core.publisher.FluxIterable.subscribe(FluxIterable.java:201) at reactor.core.publisher.FluxIterable.subscribe(FluxIterable.java:83) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDeferContextual.subscribe(MonoDeferContextual.java:55) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.netty.http.server.HttpServer$HttpServerHandle.onStateChange(HttpServer.java:1112) at reactor.netty.ReactorNetty$CompositeConnectionObserver.onStateChange(ReactorNetty.java:707) at reactor.netty.transport.ServerTransport$ChildObserver.onStateChange(ServerTransport.java:481) at reactor.netty.http.server.HttpServerOperations.onInboundNext(HttpServerOperations.java:626) at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:114) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at reactor.netty.http.server.HttpTrafficHandler.channelRead(HttpTrafficHandler.java:230) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.lang.Thread.run(Thread.java:750) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:648) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:567) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:544) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) 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.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy222.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) 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.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy220.query(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy219.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) 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:427) at com.sun.proxy.$Proxy116.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy121.selectList(Unknown Source) at com.baomidou.mybatisplus.core.mapper.BaseMapper.selectOne(BaseMapper.java:172) at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$DefaultMethodInvoker.invoke(MybatisMapperProxy.java:162) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy121.selectOne(Unknown Source) at com.hvlink.service.impl.AsnMainServiceImpl.updateCancelReleaseStatus(AsnMainServiceImpl.java:822) at com.hvlink.service.impl.AsnMainServiceImpl$$FastClassBySpringCGLIB$$906a1c7c.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:792) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:762) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:707) at com.hvlink.service.impl.AsnMainServiceImpl$$EnhancerBySpringCGLIB$$70692874.updateCancelReleaseStatus(<generated>) at com.hvlink.controller.AsnMainController.updateCancelReleaseStatus(AsnMainController.java:83) 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.reactive.result.method.InvocableHandlerMethod.lambda$invoke$0(InvocableHandlerMethod.java:145) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:125) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.Operators$MonoSubscriber.complete(Operators.java:1839) at reactor.core.publisher.MonoZip$ZipCoordinator.signal(MonoZip.java:258) at reactor.core.publisher.MonoZip$ZipInner.onNext(MonoZip.java:347) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.FluxDefaultIfEmpty$DefaultIfEmptySubscriber.onNext(FluxDefaultIfEmpty.java:101) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:74) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2400) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.request(FluxOnAssembly.java:649) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2196) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onSubscribe(Operators.java:2070) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onSubscribe(FluxOnAssembly.java:633) at reactor.core.publisher.FluxFlatMap.trySubscribeScalarMap(FluxFlatMap.java:192) at reactor.core.publisher.MonoFlatMap.subscribeOrReturn(MonoFlatMap.java:53) at reactor.core.publisher.Mono.subscribe(Mono.java:4475) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:129) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:240) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.onComplete(MonoIgnoreThen.java:203) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onComplete(FluxOnAssembly.java:549) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onComplete(MonoFlatMap.java:181) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onComplete(FluxOnAssembly.java:549) at reactor.core.publisher.Operators.complete(Operators.java:137) at reactor.core.publisher.MonoZip.subscribe(MonoZip.java:121) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoFlatMap$FlatMapMain.onNext(MonoFlatMap.java:157) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.FluxSwitchIfEmpty$SwitchIfEmptySubscriber.onNext(FluxSwitchIfEmpty.java:74) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.MonoNext$NextSubscriber.onNext(MonoNext.java:82) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.innerNext(FluxConcatMap.java:282) at reactor.core.publisher.FluxConcatMap$ConcatMapInner.onNext(FluxConcatMap.java:863) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onNext(FluxMapFuseable.java:129) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onNext(MonoPeekTerminal.java:180) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onNext(FluxOnAssembly.java:539) at reactor.core.publisher.Operators$ScalarSubscription.request(Operators.java:2400) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.request(FluxOnAssembly.java:649) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.request(MonoPeekTerminal.java:139) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.request(FluxOnAssembly.java:649) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.request(FluxMapFuseable.java:171) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.request(FluxOnAssembly.java:649) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.set(Operators.java:2196) at reactor.core.publisher.Operators$MultiSubscriptionSubscriber.onSubscribe(Operators.java:2070) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onSubscribe(FluxOnAssembly.java:633) at reactor.core.publisher.FluxMapFuseable$MapFuseableSubscriber.onSubscribe(FluxMapFuseable.java:96) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onSubscribe(FluxOnAssembly.java:633) at reactor.core.publisher.MonoPeekTerminal$MonoTerminalPeekSubscriber.onSubscribe(MonoPeekTerminal.java:152) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onSubscribe(FluxOnAssembly.java:633) at reactor.core.publisher.MonoJust.subscribe(MonoJust.java:55) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.drain(FluxConcatMap.java:451) at reactor.core.publisher.FluxConcatMap$ConcatMapImmediate.onSubscribe(FluxConcatMap.java:219) at reactor.core.publisher.FluxOnAssembly$OnAssemblySubscriber.onSubscribe(FluxOnAssembly.java:633) at reactor.core.publisher.FluxIterable.subscribe(FluxIterable.java:201) at reactor.core.publisher.FluxIterable.subscribe(FluxIterable.java:83) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDefer.subscribe(MonoDefer.java:53) at reactor.core.publisher.Mono.subscribe(Mono.java:4490) at reactor.core.publisher.MonoIgnoreThen$ThenIgnoreMain.subscribeNext(MonoIgnoreThen.java:263) at reactor.core.publisher.MonoIgnoreThen.subscribe(MonoIgnoreThen.java:51) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.core.publisher.MonoDeferContextual.subscribe(MonoDeferContextual.java:55) at reactor.core.publisher.InternalMonoOperator.subscribe(InternalMonoOperator.java:64) at reactor.netty.http.server.HttpServer$HttpServerHandle.onStateChange(HttpServer.java:1112) at reactor.netty.ReactorNetty$CompositeConnectionObserver.onStateChange(ReactorNetty.java:707) at reactor.netty.transport.ServerTransport$ChildObserver.onStateChange(ServerTransport.java:481) at reactor.netty.http.server.HttpServerOperations.onInboundNext(HttpServerOperations.java:626) at reactor.netty.channel.ChannelOperationsHandler.channelRead(ChannelOperationsHandler.java:114) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at reactor.netty.http.server.HttpTrafficHandler.channelRead(HttpTrafficHandler.java:230) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at io.netty.channel.CombinedChannelDuplexHandler$DelegatingChannelHandlerContext.fireChannelRead(CombinedChannelDuplexHandler.java:436) at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:346) at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:318) at io.netty.channel.CombinedChannelDuplexHandler.channelRead(CombinedChannelDuplexHandler.java:251) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:442) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412) at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440) at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420) at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919) at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166) at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788) at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724) at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650) at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562) at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997) at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30) at java.lang.Thread.run(Thread.java:750) 2025-09-29 16:32:04.100 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.annotation.ResponseBodyResultHandler - [0d852c52-5] Using &#39;application/json&#39; given [*/*] and supported [application/json, application/*+json, application/x-ndjson, text/event-stream] 2025-09-29 16:32:04.100 [reactor-http-nio-2] DEBUG o.s.w.r.r.m.annotation.ResponseBodyResultHandler - [0d852c52-5] 0..1 [com.hvlink.common.Result<?>] 2025-09-29 16:32:04.100 [reactor-http-nio-2] DEBUG o.s.http.codec.json.Jackson2JsonEncoder - [0d852c52-5] Encoding [Result(status=500, msg=发现未知问题，请联系管理员！, data=null, timestamp=1759134724100)] 2025-09-29 16:32:04.101 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [0d852c52-3, L:/192.168.10.130:9002 - R:/192.168.10.130:45061] Decreasing pending responses, now 0 2025-09-29 16:32:04.101 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [0d852c52-3, L:/192.168.10.130:9002 - R:/192.168.10.130:45061] Last HTTP packet was sent, terminating the channel 2025-09-29 16:32:04.101 [reactor-http-nio-2] DEBUG reactor.netty.channel.ChannelOperations - [0d852c52-3, L:/192.168.10.130:9002 - R:/192.168.10.130:45061] [HttpServer] Channel inbound receiver cancelled (operation cancelled). 2025-09-29 16:32:04.101 [reactor-http-nio-2] DEBUG o.s.web.server.adapter.HttpWebHandlerAdapter - [0d852c52-5] Completed 500 INTERNAL_SERVER_ERROR 2025-09-29 16:32:04.101 [reactor-http-nio-2] DEBUG reactor.netty.http.server.HttpServerOperations - [0d852c52-3, L:/192.168.10.130:9002 - R:/192.168.10.130:45061] Last HTTP response frame
      最新发布
      09-30
      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 列名 &#39;create_by&#39; 无效。 ``` --- ### ❌ 问题分析 #### 错误日志关键点： ```sql SQL: SELECT id, company_code, ..., create_by, create_time, ...
      iBatis中报 java.sql.SQLException: 无效的列类型异常
      runwuwushengxiyu的博客
      06-12 167
      iBatis中报 java.sql.SQLException: 无效的列类型异常
      解决iBATIS动态改变查询字段出现“java.sql.SQLException: 列名无效” 错误的方法...
      那些比你走的远的人，并非就比你聪明，只是每天多走了一点
      12-26 536
      &lt;select id="XX" resultClass="java.util.HashMap" parameterClass="java.util.HashMap" &gt; select yyyymmdd, &lt;isNotEmpty prepend=" " property="user_type"&gt; &lt
      解决iBATIS动态改变查询字段出现“java.sql.SQLException: 列名无效” 错误的方法
      iteye_20053的博客
      02-29 240
      http://jaykuen.iteye.com/blog/852086 Xml代码 select yyyymmdd, a b ...
      IBATIS列名无效
      xiuson回忆录
      05-26 2605
      作者：xiuson, 原文发表于：http://www.xiuson.com/?p=66 最近在用ibatis连接Oracle，出现了几种列名无效的情况： — The error occurred in com/kingdee/youshang/basedata/mapper/ProductOnSale.xml. — The error occurred while ap
      数据库列名无效
      学过印刷包装工程研究过食品科学且会点计算机编程的多功能码农
      10-22 5617
      如果提示 列名无效，可能是   1）数据库连接错误。 改改语句试试，检查数据库连接。   2）sql错误。带回查询分析器试试。   3）(据楼上某仁兄说)可能是关键字命名冲突，也有可能。   4）可能是数据类型冲突。检查是否匹配。
      "列名无效"的问题
      热门推荐
      老菜鸟
      08-02 8万+
      反思"列名无效"的问题 标签： 数据库serverdatabasebuttonsqlobject 2011-03-16 21:09 8531人阅读 评论(3) 收藏 举报  分类： c# || .net（24）  版权声明：本文为博主原创文章，未经博主允许不得转载。 发帖解决了~！贴在地址： http://topic.csdn.ne
      SQL server列名无效问题
      weixin_45044713的博客
      06-24 9514
      这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 欢迎使用M...
      评论
      添加红包

      请填写红包祝福语或标题

      个

      红包个数最小为10个

      元

      红包金额最低5元

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

      抵扣说明：

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

      余额充值