org.h2.jdbc.JdbcSQLException

tip

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


rafaelrafael

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • Unhandled exception parsing date
    via by Mike Goodwin,
  • H2 Oracle decode function
    via Stack Overflow by SvRekaa
    ,
  • Failover @Type for h2?
    via Stack Overflow by xenoterracide
    ,
  • Ebean/idIn Parameter not set
    via Stack Overflow by Janus Troelsen
    ,
  • Remote procedure call error
    via GitHub by milci199
    ,
    • 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

    aidoanaidoan
    1 times, last one,
    kjhdofjosvskjhdofjosvs
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    144 more bugmates