net.sf.jsqlparser.parser.ParseException

Encountered " "(" "( "" at line 1, column 12. Was expecting one of: <EOF> "AS" ... "DO" ... "ANY" ... "KEY" ... "PERCENT" ... "INTO" ... "FROM" ... "OPEN" ... "WHERE" ... "FOR" ... "XML" ... "GROUP" ... "VALUE" ... "HAVING" ... "VALUES" ... "REPLACE" ... "TRUNCATE" ... "CAST" ... "OVER" ... "PARTITION" ... "EXTRACT" ... "MATERIALIZED" ... "START" ... "CONNECT" ... "PRIOR" ... "SIBLINGS" ... "COLUMN" ... "NULLS" ... "FIRST" ... "LAST" ... "ROWS" ... "RANGE" ... "FOLLOWING" ... "ROW" ... "SEPARATOR" ... "CASCADE" ... "NO" ... "ACTION" ... <S_IDENTIFIER> ... <S_QUOTED_IDENTIFIER> ... ";" ... "," ... "+" ... "||" ... "|" ... "&" ... "-" ... "^" ... "::" ... "::" ... "^" ... "+" ... "-" ... "||" ... "|" ... "&" ... "AS" ... <S_IDENTIFIER> ... <S_QUOTED_IDENTIFIER> ... "CAST" ... "DO" ... "EXTRACT" ... "FIRST" ... "FOLLOWING" ... "LAST" ... "MATERIALIZED" ... "NULLS" ... "PARTITION" ... "RANGE" ... "ROW" ... "ROWS" ... "SIBLINGS" ... "VALUE" ... "XML" ... "COLUMN" ... "REPLACE" ... "TRUNCATE" ... "KEY" ... "ANY" ... "OPEN" ... "OVER" ... "VALUES" ... "PERCENT" ... "PRIOR" ... "SEPARATOR" ... "NO" ... "ACTION" ... "CASCADE" ... "," ... "INTO" ... "FROM" ... "WHERE" ... "START" ... "CONNECT" ... "GROUP" ... "HAVING" ... "FOR" ...

Solutions on the web47

  • " ... "XML" ... "COLUMN" ... "REPLACE" ... "TRUNCATE" ... "KEY" ... "ANY" ... "OPEN" ... "OVER" ... "VALUES" ... "PERCENT" ... "PRIOR" ... "SEPARATOR" ... "NO" ... "ACTION" ... "CASCADE" ... "," ... "INTO" ... "FROM" ... "WHERE" ... "START" ... "CONNECT" ... "GROUP" ... "HAVING" ... "FOR" ...
  • via GitHub by benkris1
    , 1 year ago
    Encountered " <S_LONG> "568 "" at line 1, column 13. Was expecting one of: "DO" ... "ANY" ... "KEY" ... "PERCENT" ... "OPEN" ... "XML" ... "VALUE" ... "VALUES" ... "REPLACE" ... "TRUNCATE" ... "CAST
  • via GitHub by iszilagyigit
    , 1 year ago
    Encountered " "(" "( "" at line 1, column 15. Was expecting one of: <EOF> "AS" ... "DO" ... "ANY" ... "KEY" ... "INTO" ... "FROM" ... "WHERE" ... "FOR" ... "XML" ... "GROUP" ... "VALUE
  • Stack trace

    • net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 1, column 12. Was expecting one of: <EOF> "AS" ... "DO" ... "ANY" ... "KEY" ... "PERCENT" ... "INTO" ... "FROM" ... "OPEN" ... "WHERE" ... "FOR" ... "XML" ... "GROUP" ... "VALUE" ... "HAVING" ... "VALUES" ... "REPLACE" ... "TRUNCATE" ... "CAST" ... "OVER" ... "PARTITION" ... "EXTRACT" ... "MATERIALIZED" ... "START" ... "CONNECT" ... "PRIOR" ... "SIBLINGS" ... "COLUMN" ... "NULLS" ... "FIRST" ... "LAST" ... "ROWS" ... "RANGE" ... "FOLLOWING" ... "ROW" ... "SEPARATOR" ... "CASCADE" ... "NO" ... "ACTION" ... <S_IDENTIFIER> ... <S_QUOTED_IDENTIFIER> ... ";" ... "," ... "+" ... "||" ... "|" ... "&" ... "-" ... "^" ... "::" ... "::" ... "^" ... "+" ... "-" ... "||" ... "|" ... "&" ... "AS" ... <S_IDENTIFIER> ... <S_QUOTED_IDENTIFIER> ... "CAST" ... "DO" ... "EXTRACT" ... "FIRST" ... "FOLLOWING" ... "LAST" ... "MATERIALIZED" ... "NULLS" ... "PARTITION" ... "RANGE" ... "ROW" ... "ROWS" ... "SIBLINGS" ... "VALUE" ... "XML" ... "COLUMN" ... "REPLACE" ... "TRUNCATE" ... "KEY" ... "ANY" ... "OPEN" ... "OVER" ... "VALUES" ... "PERCENT" ... "PRIOR" ... "SEPARATOR" ... "NO" ... "ACTION" ... "CASCADE" ... "," ... "INTO" ... "FROM" ... "WHERE" ... "START" ... "CONNECT" ... "GROUP" ... "HAVING" ... "FOR" ... at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:13996) at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:13852) at net.sf.jsqlparser.parser.CCJSqlParser.Statements(CCJSqlParser.java:236) at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:122)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago