Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

  1. ,
    Expert tip

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

Solutions on the web

via GitHub by thomasmueller
, 1 year ago
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]
via GitHub by velo
, 1 year ago
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]
via Google Groups by Victor Shcherb, 7 months ago
Column "N.ID" must be in the GROUP BY list; > SQL statement: > select count(*) from node n inner join tags t on n.id = t.id and t.type = > 0 order by n.id [90016-158]
via Stack Overflow by gabriel angelos
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-169]
via GitHub by marcellodesales
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]
via GitHub by marcellodesales
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]
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)