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


Solutions on the web

Solution icon of googlegroups
via Google Groups by Mike Goodwin, 9 months ago
Cannot parse "DATE" constant ; SQL statement: ... FROM (SELECT NULL) WHERE (true) LIMIT 25000 [22007-193]

Solution icon of googlegroups
via Google Groups by Krzysztof Chudy, 1 year ago
Nie można odczytać "TIMESTAMP" jako "1" Cannot parse "TIMESTAMP" constant "1"; SQL statement: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where ( t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ? [22007-189]

Solution icon of github
Nie można odczytać "TIMESTAMP" jako "1" Cannot parse "TIMESTAMP" constant "1"; SQL statement: select t0.id c0, t0.inactive c1, t0.name c2, t0.email c3, t0.version c4, t0.when_created c5, t0.when_modified c6, t0.group_id c7 from c_user_with_history t0 where (t0.sys_period_start <= ? and (t0.sys_period_end is null or t0.sys_period_end > ?)) and t0.id = ? [22007-189]

Solution icon of stackoverflow
Cannot parse "TIMESTAMP" constant "07/16/2011 02:43:43"; SQL statement: -- row #2 ('CIRCLE', 'MSISDN', 'PORT_IN_DATE', 'OPERATOR', 'PRODUCT_TYPE', 'PORT_ID') [22007-163]

Solution icon of github
via GitHub by Sami32
, 9 months ago
Out of memory.; SQL statement: SELECT * FROM FILES WHERE FILENAME = ? AND MODIFIED = ? [90108-193]

Solution icon of github
Table "CITY" not found; SQL statement: select * from city where state = ? [42102-193]

Solution icon of stackoverflow
via Stack Overflow by Travis Sharp
, 10 months ago
Syntax error in SQL statement "SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG = ?,[*] TABLE_SCHEMA = ?"; SQL statement: SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG = ?, TABLE_SCHEMA = ? [42000-193]

Solution icon of web
via nxtforum.org by Unknown author, 1 year ago
IO Exception: "java.io.IOException: Stream Closed"; "/root/nxt/nxt_test_db/nxt.h2.db"; SQL statement: SELECT * FROM account WHERE id = ?  AND latest = TRUE LIMIT 1 [90031-192]

Solution icon of github
Table "QUEUED_SHARED_TASK_LOCKS" not found; SQL statement: with recursive t (queue_id) as ((select queue_id from queued_shared_task_locks where hold_expire_time is null order by queue_id limit 1) union all select (select queue_id from

Solution icon of github
Table "QUEUED_SHARED_TASK_LOCKS" not found; SQL statement: with recursive t (queue_id) as ((select queue_id from queued_shared_task_locks where hold_expire_time is null order by queue_id limit 1) union all select (select queue_id from

Stack trace

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)

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

Once, 4 months ago
Once, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
149 more bugmates