sql关键字与系统冲突报错 Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token:

sfreedt

已于 2022-10-18 17:18:44 修改

阅读量5.4k

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库 java BUG 文章标签： sql 数据库

于 2022-10-18 16:00:39 首次发布

本文链接：https://blog.youkuaiyun.com/sfreedt/article/details/127390316

数据库同时被 2 个专栏收录

3 篇文章

订阅专栏

java BUG

3 篇文章

订阅专栏

当遇到'ORDER BY'等SQL关键字引发的net.sf.jsqlparser.parser.ParseException时，解决方案包括为字段名和别名添加双引号，或者针对MyBatisPlus调整配置文件以避免系统冲突。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

sql关键字与系统冲突报错 Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: “ORDER” “order”

at line 5, column 10.Was expecting one of: "ACTION" "ANY" "BYTE"

Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ORDER" "order"
    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>