org.h2.jdbc.JdbcSQLException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
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.

  • GitHub comment 321#233844005
    via GitHub by thomasmueller
    ,
  • 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: 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] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:169) at org.h2.expression.Comparison.updateAggregate(Comparison.java:461) at org.h2.expression.Function.updateAggregate(Function.java:2607) at org.h2.command.dml.Select.queryGroup(Select.java:364) at org.h2.command.dml.Select.queryWithoutCache(Select.java:649) 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:36) at org.h2.command.CommandContainer.query(CommandContainer.java:110) 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