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.

  • Getting an odd sql exception?
    via hsqldb by nobody
    ,
  • Why is this alias not found?
    via hsqldb by johansend
    ,
  • Server Error Logs
    via by 843841,
  • informix sql
    via hsqldb by nobody
    ,
  • Possible bug with 1.7.1 RC2
    via hsqldb by jeffcampbell
    ,
  • Assert Failed inside of Hypersonic
    via hsqldb by johansend
    ,
  • HSQLDB 1.7.0 Checkpoint Exception
    via hsqldb by matts28
    ,
  • Problem with SELECT expression
    via hsqldb by surdules
    ,
    • java.sql.SQLException: Not contained in aggregate function or group by clause: COLUMN KONTONAVN in statement \[select kp.kontonr,kp.kontonavn,kp.type,m.navn,sum(kr.debit),sum(kr.kredit),sum(kr.saldo),sum(fkp.saldo),sum(momsbeloeb),kp.id,kp.sumfra,fk.kontonr,m.kontonr,kp.momsid from kontoplan as kp left join kasserapport as kr on kr.kontonr = kp.kontonr left join fastekonti as fk on fk.kontonr = kp.kontonr left join fastekontiposter as fkp on fkp.fastekontiid = fk.id left join moms as m on m.kontonr = kp.kontonr left join momsposter as mp on mp.momsid = m.id group by kp.kontonr\] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.executeQuery(Unknown Source) at kontoplan.funktion.ConnectDB.select(ConnectDB.java:48)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,