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

Google Groups | Mike Goodwin | 1 month ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Unhandled exception parsing date

    Google Groups | 1 month ago | Mike Goodwin
    org.h2.jdbc.JdbcSQLException: Cannot parse "DATE" constant ; SQL statement: ... FROM (SELECT NULL) WHERE (true) LIMIT 25000 [22007-193]
  2. 0

    Unable to use prepared statement + case + group By

    GitHub | 7 months ago | velo
    org.h2.jdbc.JdbcSQLException: Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]
  3. 0

    Issue H2 Parser GROUP BY, 1.4.181 -> 1.4.184

    Google Groups | 2 years ago | Nicolas Fortin (OrbisGIS)
    org.h2.jdbc.JdbcSQLException: Invalid use of aggregate function "SUM(B.VAL)"; SQL statement: select a.id, POWER(a.val, sum(b.val)) val from test a,test b group by a.id, a.val [90054-184]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 321#233844005

    GitHub | 7 months ago | thomasmueller
    org.h2.jdbc.JdbcSQLException: Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]

  1. kjhdofjosvs 1 times, last 3 months ago
6 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. H2 Database Engine
    JdbcPreparedStatement.executeQuery
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:168)
    3. org.h2.value.ValueDate.parse(ValueDate.java:81)
    4. org.h2.value.Value.convertTo(Value.java:928)
    5. org.h2.expression.Function.getSimpleValue(Function.java:1084)
    6. org.h2.expression.Function.getValueWithArgs(Function.java:1195)
    7. org.h2.expression.Function.getValue(Function.java:590)
    8. org.h2.expression.ExpressionList.getValue(ExpressionList.java:32)
    9. org.h2.expression.JavaAggregate.updateAggregate(JavaAggregate.java:192)
    10. org.h2.expression.Function.updateAggregate(Function.java:2663)
    11. org.h2.expression.Alias.updateAggregate(Alias.java:87)
    12. org.h2.command.dml.Select.queryGroup(Select.java:365)
    13. org.h2.command.dml.Select.queryWithoutCache(Select.java:650)
    14. org.h2.command.dml.Query.query(Query.java:341)
    15. org.h2.command.dml.Query.query(Query.java:309)
    16. org.h2.expression.Subquery.getValue(Subquery.java:36)
    17. org.h2.expression.ExpressionList.getValue(ExpressionList.java:32)
    18. org.h2.expression.Alias.getValue(Alias.java:36)
    19. org.h2.command.dml.Select.queryFlat(Select.java:549)
    20. org.h2.command.dml.Select.queryWithoutCache(Select.java:655)
    21. org.h2.command.dml.Query.query(Query.java:341)
    22. org.h2.command.dml.Query.query(Query.java:309)
    23. org.h2.command.dml.Query.query(Query.java:1)
    24. org.h2.command.CommandContainer.query(CommandContainer.java:112)
    25. org.h2.command.Command.executeQuery(Command.java:201)
    26. org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)
    26 frames