java.sql.SQLException: expression not in aggregate or GROUP BY columns: PUBLIC.ALERTS.JULIAN\_DATE

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

Solutions on the web

via hsqldb by satrajignesh
, 1 year ago
expression not in aggregate or GROUP BY columns: PUBLIC.ALERTS.JULIAN\_DATE
via Oracle Community by user705850, 1 year ago
user lacks privilege or object not found: TO_DATE
via hsqldb by zhaozhihua2008
, 1 year ago
user lacks privilege or object not found: TB\_A3B9
via Oracle Community by Harish Kakaraparthy-Oracle, 1 year ago
via Oracle Community by Papai, 1 year ago
user lacks privilege or object not found: I$_CLIENT_TABLE
via Oracle Community by 3162137, 1 year ago
user lacks privilege or object not found: SHIPORDER.SHIPORDERPK
java.sql.SQLException: expression not in aggregate or GROUP BY columns: PUBLIC.ALERTS.JULIAN\_DATE
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCPreparedStatement.(Unknown Source)
at com.lb.cmte.oms.ws.backend.db.SQLStatementCache.addStatement(SQLStatementCache.java:103)
at com.lb.cmte.oms.ws.backend.db.SQLStatementCache.getByKey(SQLStatementCache.java:69)
at com.lb.cmte.oms.ws.backend.exception.AlertDAO.query(AlertDAO.java:167)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
10 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
11 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.