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

hsqldb | satrajignesh | 6 years ago
  1. 0

    Problem with Select statement

    hsqldb | 6 years ago | satrajignesh
    java.sql.SQLException: expression not in aggregate or GROUP BY columns: PUBLIC.ALERTS.JULIAN\_DATE
  2. 0

    Date data load error while loading xml data to oracle db

    Oracle Community | 4 years ago | user705850
    java.sql.SQLException: user lacks privilege or object not found: TO_DATE
  3. 0

    odi 11g - malformed numeric constant thru view data

    Oracle Community | 3 years ago | user645637
    java.sql.SQLException: malformed numeric constant
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    error loading mutiple xml files in odi 11g

    Oracle Community | 3 years ago | user6322937
    java.sql.SQLException: user lacks privilege or object not found: PMCDS_PHASE_EVENT.DEVICETYPE
  6. 0

    ODI-1228 CKM Hypersonic SQL

    Oracle Community | 3 years ago | 76ac2290-b565-4029-9b0e-4e69120b7d17
    java.sql.SQLException: unknown word

  1. WoodenDoors 10 times, last 8 months ago
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

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

    at org.hsqldb.jdbc.Util.sqlException()
  2. HSQLDB
    JDBCConnection.prepareStatement
    1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
    2. org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
    3. org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
    3 frames
  3. com.lb.cmte
    AlertDAO.query
    1. com.lb.cmte.oms.ws.backend.db.SQLStatementCache.addStatement(SQLStatementCache.java:103)
    2. com.lb.cmte.oms.ws.backend.db.SQLStatementCache.getByKey(SQLStatementCache.java:69)
    3. com.lb.cmte.oms.ws.backend.exception.AlertDAO.query(AlertDAO.java:167)
    3 frames