当前位置:   article > 正文

SQL报错:Encountered unexpected token: “FUNCTION“ “FUNCTION“at line 5, column 10.Was expecting one of:_encountered unexpected token: "," ",

encountered unexpected token: "," ",

写代码SQL报错,做下记录:

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "FUNCTION" "FUNCTION"
    at line 5, column 10.

Was expecting one of:

    "ACTION"
    "ANY"
    "BYTE"
    "CASCADE"
    "CAST"
    "CHANGE"
    "CHAR"
    "CHARACTER"
    "COLUMN"
    "COLUMNS"
    "COMMENT"
    "COMMIT"
    "CREATE"
    "CYCLE"
    "DESC"
    "DESCRIBE"
    "DISABLE"
    "DIV"
    "DO"
    "DOUBLE"
    "DUPLICATE"
    "ENABLE"
    "END"
    "EXCLUDE"
    "EXTRACT"
    "FALSE"
    "FIRST"
    "FN"
    "FOLLOWING"
    "FORMAT"
    "GROUP"
    "IF"
    "INDEX"
    "INSERT"
    "INTERVAL"
    "ISNULL"
    "KEY"
    "LAST"
    "LEFT"
    "LIMIT"
    "MATERIALIZED"
    "NEXTVAL"
    "NO"
    "NOLOCK"
    "NULLS"
    "OF"
    "OFFSET"
    "ON"
    "OPEN"
    "OPTIMIZE"
    "ORDER"
    "OVER"
    "PARTITION"
    "PATH"
    "PERCENT"
    "PRECISION"
    "PRIMARY"
    "PRIOR"
    "PROCEDURE"
    "PUBLIC"
    "RANGE"
    "READ"
    "REPLACE"
    "RIGHT"
    "ROW"
    "ROWS"
    "SCHEMA"
    "SEPARATOR"
    "SEQUENCE"
    "SESSION"
    "SET"
    "SIBLINGS"
    "SIZE"
    "START"
    "TABLE"
    "TABLES"
    "TEMP"
    "TEMPORARY"
    "TO"
    "TOP"
    "TRUE"
    "TRUNCATE"
    "TYPE"
    "UNSIGNED"
    "VALIDATE"
    "VALUE"
    "VALUES"
    "VIEW"
    "XML"
    "ZONE"
    <K_DATETIMELITERAL>
    <K_DATE_LITERAL>
    <S_IDENTIFIER>
    <S_QUOTED_IDENTIFIER>
  • 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
  • 95
  • 96
  • 97
  • 98
  • 99

原因是,sql中有一个字段为关键字:FUNCTION

    <insert id="insertBusiInfoGrade" parameterType="com.andawell.ipd.platform.business.domain.business.entity.po.BusiReqGradePO">
        insert into BUSI_REQ_GRADE
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="busiReqGradeId != null">BUSI_REQ_GRADE_ID,</if>
            <if test="busiInfoId != null">BUSI_INFO_ID,</if>
            <if test="dataType != null">DATA_TYPE,</if>
            <if test="marketName != null">MARKET_NAME,</if>
            <if test="competitorName != null">COMPETITOR_NAME,</if>
            <if test="gradeGoodsName != null">GRADE_GOODS_NAME,</if>
            <if test="price != null">PRICE,</if>
            <if test="schedule != null">SCHEDULE,</if>
            <if test="packing != null">PACKING,</if>
            <if test="function != null">FUNCTION,</if>
            <if test="accessibility != null">ACCESSIBILITY,</if>
            <if test="serverName != null">SERVER_NAME,</if>
            <if test="lifeCyclePrice != null">LIFE_CYCLE_PRICE,</if>
            <if test="brand != null">BRAND,</if>
            <if test="createdBy != null">CREATED_BY,</if>
            <if test="creationDate != null">CREATION_DATE,</if>
            <if test="lastUpdatedBy != null">LAST_UPDATED_BY,</if>
            <if test="lastUpdatedDate != null">LAST_UPDATED_DATE,</if>
            <if test="lastUpdateIp != null">LAST_UPDATE_IP,</if>
            <if test="version != null">VERSION,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="busiReqGradeId != null"> #{busiReqGradeId,jdbcType=VARCHAR},</if>
            <if test="busiInfoId != null"> #{busiInfoId,jdbcType=VARCHAR},</if>
            <if test="dataType != null"> #{dataType,jdbcType=VARCHAR},</if>
            <if test="marketName != null"> #{marketName,jdbcType=VARCHAR},</if>
            <if test="competitorName != null"> #{competitorName,jdbcType=VARCHAR},</if>
            <if test="gradeGoodsName != null"> #{gradeGoodsName,jdbcType=VARCHAR},</if>
            <if test="price != null"> #{price,jdbcType=DECIMAL},</if>
            <if test="schedule != null"> #{schedule,jdbcType=VARCHAR},</if>
            <if test="packing != null"> #{packing,jdbcType=VARCHAR},</if>
            <if test="function != null"> #{function,jdbcType=VARCHAR},</if>
            <if test="accessibility != null"> #{accessibility,jdbcType=VARCHAR},</if>
            <if test="serverName != null"> #{serverName,jdbcType=VARCHAR},</if>
            <if test="lifeCyclePrice != null"> #{lifeCyclePrice,jdbcType=VARCHAR},</if>
            <if test="brand != null"> #{brand,jdbcType=VARCHAR},</if>
            <if test="createdBy != null"> #{createdBy,jdbcType=VARCHAR},</if>
            <if test="creationDate != null"> #{creationDate,jdbcType=TIMESTAMP},</if>
            <if test="lastUpdatedBy != null"> #{lastUpdatedBy,jdbcType=VARCHAR},</if>
            <if test="lastUpdatedDate != null"> #{lastUpdatedDate,jdbcType=TIMESTAMP},</if>
            <if test="lastUpdateIp != null"> #{lastUpdateIp,jdbcType=VARCHAR},</if>
            <if test="version != null"> #{version,jdbcType=DECIMAL},</if>
        </trim>
    </insert>
  • 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
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/喵喵爱编程/article/detail/894165?site
推荐阅读
相关标签
  

闽ICP备14008679号