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

Stack Overflow | Stephan | 3 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Why H2 database doesn't find my column?

    Stack Overflow | 3 months ago | Stephan
    org.h2.jdbc.JdbcSQLException: Column "NB" not found; SQL statement: select top nb label from foo [42122-192]
  2. 0

    how to create a standalone grails app with h2 db by using standalone plugin?

    Stack Overflow | 4 years ago | Guille
    org.h2.jdbc.JdbcSQLException: Table "COMPANY" not found; SQL statement: select this_.id as id15_0_, this_.version as version15_0_, this_.name as name15_0_ from company this_ limit ? [42102-164]
  3. 0

    Why do I get an H2 error when deploying my Grails WAR to Tomcat

    Stack Overflow | 3 years ago | TheAmpersand
    org.h2.jdbc.JdbcSQLException: Table "MONKEY_CLASSIFICATION" not found; SQL statement: select count(*) as y0_ from monkey_classification this_ [42102-164]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't initialize the database...

    GitHub | 2 years ago | victornoel
    org.waarp.common.database.exception.WaarpDatabaseSqlException: SQL Exception Request:SELECT * FROM CONFIGURATION
  6. 0

    Unexpected exception while inserting rows with query literals disabled

    Google Groups | 4 years ago | Michael Diamond
    org.h2.jdbc.JdbcSQLException: Literals of this kind are not allowed; SQL statement: SELECT UPPER(VALUE) FROM INFORMATION_SCHEMA.SETTINGS WHERE NAME='MODE' [90116-173]

    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. org.h2.jdbc.JdbcSQLException

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

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      WebThread.run
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
      2. org.h2.message.DbException.get(DbException.java:179)
      3. org.h2.message.DbException.get(DbException.java:155)
      4. org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
      5. org.h2.command.Parser.parseSelectSimpleSelectPart(Parser.java:1984)
      6. org.h2.command.Parser.parseSelectSimple(Parser.java:2035)
      7. org.h2.command.Parser.parseSelectSub(Parser.java:1890)
      8. org.h2.command.Parser.parseSelectUnion(Parser.java:1711)
      9. org.h2.command.Parser.parseSelect(Parser.java:1699)
      10. org.h2.command.Parser.parsePrepared(Parser.java:445)
      11. org.h2.command.Parser.parse(Parser.java:317)
      12. org.h2.command.Parser.parse(Parser.java:289)
      13. org.h2.command.Parser.prepareCommand(Parser.java:254)
      14. org.h2.engine.Session.prepareLocal(Session.java:560)
      15. org.h2.engine.Session.prepareCommand(Session.java:501)
      16. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)
      17. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:170)
      18. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
      19. org.h2.server.web.WebApp.getResult(WebApp.java:1388)
      20. org.h2.server.web.WebApp.query(WebApp.java:1061)
      21. org.h2.server.web.WebApp$1.next(WebApp.java:1023)
      22. org.h2.server.web.WebApp$1.next(WebApp.java:1010)
      23. org.h2.server.web.WebThread.process(WebThread.java:164)
      24. org.h2.server.web.WebThread.run(WebThread.java:89)
      24 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame