org.h2.jdbc.JdbcSQLException: Cannot parse "DATE" constant ; SQL statement: ... FROM (SELECT NULL) WHERE (true) LIMIT 25000 [22007-193]

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

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via Google Groups by Mike Goodwin, 11 months ago
Cannot parse "DATE" constant ; SQL statement: ... FROM (SELECT NULL) WHERE (true) LIMIT 25000 [22007-193]
via Google Groups by Navjot Singh, 2 years ago
Timeout trying to lock table "TRACKED_ASSET100"; SQL statement: insert into TRACKED_ASSET100 ( ......) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [50200-157]
via Stack Overflow by manish rajput
, 7 months ago
General error: "java.lang.ArrayIndexOutOfBoundsException"; SQL statement: delete from FINACLECOREAPPNEWPRREPPAIR1492520606640_SCANNEDLIST where file_path=? and lastModifiedTime=? [50000-171]
via Stack Overflow by sonoerin
, 2 years ago
Unique index or primary key violation: "PRIMARY_KEY_4 ON PUBLIC.USERS(USERNAME)"; SQL statement: INSERT INTO users (username, password, enabled) VALUES ('admin', '$2a$10$GVPAMYRozI08Mcll5too6.Q4M2jTO0iJVoiaVDv9pMxRqTpxNj9vO', TRUE) [23505-172]
via osdir.com by Unknown author, 1 year ago
Kann "DATE" "2000-01-02 00:00:00" nicht umwandelnCannot parse "DATE" constant "2000-01-02 00:00:00"; SQL statement:
via google.com by Unknown author, 2 years ago
NULL not allowed for column "Y"; SQL statement: INSERT INTO table (x, y) VALUES (?, ?) ON DUPLICATE KEY UPDATE y = y + VALUES(y) [23502-174]
org.h2.jdbc.JdbcSQLException: Cannot parse "DATE" constant ; SQL statement: ... FROM (SELECT NULL) WHERE (true) LIMIT 25000 [22007-193]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:168)
at org.h2.value.ValueDate.parse(ValueDate.java:81)
at org.h2.value.Value.convertTo(Value.java:928)
at org.h2.expression.Function.getSimpleValue(Function.java:1084)
at org.h2.expression.Function.getValueWithArgs(Function.java:1195)
at org.h2.expression.Function.getValue(Function.java:590)
at org.h2.expression.ExpressionList.getValue(ExpressionList.java:32)
at org.h2.expression.JavaAggregate.updateAggregate(JavaAggregate.java:192)
at org.h2.expression.Function.updateAggregate(Function.java:2663)
at org.h2.expression.Alias.updateAggregate(Alias.java:87)
at org.h2.command.dml.Select.queryGroup(Select.java:365)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:650)
at org.h2.command.dml.Query.query(Query.java:341)
at org.h2.command.dml.Query.query(Query.java:309)
at org.h2.expression.Subquery.getValue(Subquery.java:36)
at org.h2.expression.ExpressionList.getValue(ExpressionList.java:32)
at org.h2.expression.Alias.getValue(Alias.java:36)
at org.h2.command.dml.Select.queryFlat(Select.java:549)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:655)
at org.h2.command.dml.Query.query(Query.java:341)
at org.h2.command.dml.Query.query(Query.java:309)
at org.h2.command.dml.Query.query(Query.java:1)
at org.h2.command.CommandContainer.query(CommandContainer.java:112)
at org.h2.command.Command.executeQuery(Command.java:201)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)

Users with the same issue

21 times, 1 week ago
2 times, 1 week ago
Once, 4 weeks ago
Once, 1 month ago
4 times, 1 month ago

Write tip

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