org.h2.jdbc.JdbcSQLException

Column "NB" not found; SQL statement: select top nb label from foo [42122-192]

Samebug tips1

tip

Check if you're not creating unused SQL entities, as it might cause this exception.


rafaelrafael

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web827

  • via Stack Overflow by Stephan
    ,
  • via Stack Overflow by ETN
    ,
  • Stack trace

    • org.h2.jdbc.JdbcSQLException: Column "NB" not found; SQL statement: select top nb label from foo [42122-192] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:179) at org.h2.message.DbException.get(DbException.java:155) at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147) at org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1984) at org.h2.command.Parser.parseSelectSimple(Parser.java:2035) at org.h2.command.Parser.parseSelectSub(Parser.java:1890) at org.h2.command.Parser.parseSelectUnion(Parser.java:1711) at org.h2.command.Parser.parseSelect(Parser.java:1699) at org.h2.command.Parser.parsePrepared(Parser.java:445) at org.h2.command.Parser.parse(Parser.java:317) at org.h2.command.Parser.parse(Parser.java:289) at org.h2.command.Parser.prepareCommand(Parser.java:254) at org.h2.engine.Session.prepareLocal(Session.java:560) at org.h2.engine.Session.prepareCommand(Session.java:501) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:170) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158) at org.h2.server.web.WebApp.getResult(WebApp.java:1388) at org.h2.server.web.WebApp.query(WebApp.java:1061) at org.h2.server.web.WebApp$1.next(WebApp.java:1023) at org.h2.server.web.WebApp$1.next(WebApp.java:1010) at org.h2.server.web.WebThread.process(WebThread.java:164) at org.h2.server.web.WebThread.run(WebThread.java:89) at java.lang.Thread.run(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    tvrmsmithtvrmsmith
    2 times, last one,
    guizmaiiguizmaii
    34 times, last one,
    batwalrus76batwalrus76
    4 times, last one,
    143 more bugmates