org.h2.jdbc.JdbcSQLException

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


Solutions on the web1059

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

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 googlegroups
via Google Groups by Krzysztof Chudy, 10 months 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 googlegroups
via Google Groups by all...@gmail.com, 1 year ago
Cannot parse date constant 2005-3-31; SQL statement: SELECT CAST('2005-3-31' AS DATE) [90009-46]

Solution icon of github
via GitHub by Sami32
, 7 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
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 stackoverflow
via Stack Overflow by Travis Sharp
, 8 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 googlegroups
via Google Groups by gaboshua, 1 year ago
Cannot parse timestamp constant 2010-04-01, cause: format hh:mm:ss; SQL statement: select count(distinct pdf_name) from qas_issue where record_disposition ='BLOCKED' and db_inserted between '2010-04-01' and '2010-05-01' [90011-63]

Solution icon of web
via nxtforum.org by Unknown author, 11 months 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]

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, 2 months ago
Once, 9 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
144 more bugmates