java.sql.SQLException: Column not found: P\_NAME in statement \[see above\]

hsqldb | johansend | 1 decade ago
  1. 0

    Why is this alias not found?

    hsqldb | 1 decade ago | johansend
    java.sql.SQLException: Column not found: P\_NAME in statement \[see above\]
  2. 0

    Getting an odd sql exception?

    hsqldb | 1 decade ago | nobody
    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\]
  3. 0

    Server Error Logs

    Oracle Community | 1 decade ago | 843841
    java.sql.SQLException: Unexpected end of command: 37000 Unexpected end of command in statement [update news" set visible=0 where ts=1070239728250]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    informix sql

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: Table not found: LEFT in statement \[ SELECT pmC\_52\_hr.rec ord\_date date, pmC\_52\_hr.start\_of\_interval time, pmC\_52\_hr.OMC\_id OMC\_id, pmC\_52 \_hr.MM\_id MM\_id, sum(IFNULL(pmC\_51\_hr.peg\_count\_1, 0)) so\_comp, sum(IFNULL(pmC\_5 1\_hr.peg\_count\_4, 0)) so\_usage FROM pmC\_52\_hr, LEFT\]
  6. 0

    Possible bug with 1.7.1 RC2

    hsqldb | 1 decade ago | jeffcampbell
    java.sql.SQLException: This function is not supported: org.hsqldb.Library.identity: java.lang.reflect.InvocationTargetException in statement \[CALL IDENTITY()\]

    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

      Column not found: P\_NAME in statement \[see above\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      6. org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
      6 frames