java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Problem with Select statement
    via hsqldb by satrajignesh
    ,
  • error loading mutiple xml files in odi 11g
    via by user6322937,
  • ODI-1228 CKM Hypersonic SQL
    via by 76ac2290-b565-4029-9b0e-4e69120b7d17,
  • Issue while writing xml file
    via by 2655429,
  • HSQL 2.0 multiple 'LIKE' exception
    via hsqldb by skoleth
    ,
    • 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.<init>(Unknown Source) at org.hsqldb.jdbc.JDBCConnection.prepareStatement(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

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    WoodenDoorsWoodenDoors
    10 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    11 more bugmates