赞
踩
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>
原因是,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>
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。