java.sql.SQLException: Unexpected token: CONCAT

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via hsqldb by asakz
, 1 year ago
Unexpected token: CONCAT
via hsqldb by nobody
, 1 year ago
Unexpected token: 37000 Unexpected token:  in statement \[DROP TABLE news \-- Create Article table CREATE\]
via hsqldb by dmiller_va
, 1 year ago
Unexpected token: 37000 Unexpected token: FOO in statemen t \[CREATE VIEW FOO\_VIEW AS  select foo() foo from dual\]
via Oracle Community by 843829, 1 year ago
Unexpected token: BINARY in statement [CREATE TABLE MLMEMBER (email VARCHAR(250) BINARY NOT NULL, name VARCHAR(250) BINARY, CONSTRAINT PK_MLMEMBER PRIMARY KEY (email))]
via hsqldb by surdules
, 1 year ago
Unexpected token: AVG in statement \[SELECT avg(value) + avg(value) FROM data;\]
via Oracle Community by 843841, 1 year ago
Unexpected end of command: 37000 Unexpected end of command in statement [update news" set visible=0 where ts=1070239728250]
java.sql.SQLException: Unexpected token: CONCAT
at org.hsqldb.Trace.getError(Trace.java:183)
at org.hsqldb.Trace.getError(Trace.java:131)
at org.hsqldb.Trace.error(Trace.java:207)
at org.hsqldb.Parser.readTerm(Parser.java:1397)
at org.hsqldb.Parser.readFactor(Parser.java:1243)
at org.hsqldb.Parser.readSum(Parser.java:1211)
at org.hsqldb.Parser.readConcat(Parser.java:1188)
at org.hsqldb.Parser.readCondition(Parser.java:1065)
at org.hsqldb.Parser.readAnd(Parser.java:1022)
at org.hsqldb.Parser.readOr(Parser.java:999)
at org.hsqldb.Parser.parseExpression(Parser.java:983)
at org.hsqldb.Parser.parseSelect(Parser.java:631)
at org.hsqldb.Parser.processSelect(Parser.java:86)
at org.hsqldb.Database.execute(Database.java:292)
at org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:1047)
at org.hsqldb.jdbcConnection.execute(jdbcConnection.java:778)
at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:686)
at org.hsqldb.jdbcStatement.execute(jdbcStatement.java:354)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.