java.sql.SQLException: Unexpected token REFERENTIAL, requires COLLATION in statement

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

Solutions on the web

via hsqldb by phil89
, 1 year ago
Unexpected token REFERENTIAL, requires COLLATION in statement
via Google Groups by Philippe COUAS, 1 year ago
Unexpected token REFERENTIAL, requires COLLATION in statement [SET DATABASE REFERENTIAL]
via unitils by phil89
, 1 year ago
Unexpected token REFERENTIAL, requires COLLATION in statement [SET DATABASE REFERENTIAL]
via Stack Overflow by developer
, 2 years ago
Assert failed: java.lang.ArrayIndexOutOfBoundsException: 23 in statement [CHECKPOINT]
via Coderanch by John Kimathi, 11 months ago
Table already exists: JMS_MESSAGES in statement [CREATE CACHED TABLE JMS_MESSAGES]
via hsqldb by *anonymous
, 1 year ago
Violation of unique constraint $$: duplicate value(s) for column(s) $$: AK\_ID\_NAMEOFID in statement \[INSERT INTO TBL\_MYSTOREDDATA\_ATTS (ID\_DATA, ATTRIBUTE1) VALUES(?, ?); \]
java.sql.SQLException: Unexpected token REFERENTIAL, requires COLLATION in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.execute(ExtendedPreparedStatement.java:136)
at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:272)
at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:246)
at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:224)
at com.avaje.ebeaninternal.server.ddl.DdlGenerator.runDdl(DdlGenerator.java:93)
at com.avaje.ebeaninternal.server.ddl.DdlGenerator.execute(DdlGenerator.java:66)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.executeDDL(DefaultServerFactory.java:347)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:229)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:123)
at com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:63)
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:64)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 2 months ago
Samebug visitor profile picture
Unknown user
Once, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 10 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
4 more bugmates

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