org.h2.jdbc.JdbcSQLException

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


Samebug tips1

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

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


Solutions on the web1134

Solution icon of stackoverflow
via Stack Overflow by Stephan
, 6 months ago
Column "NB" not found; SQL statement: select top nb label from foo [42122-192]

Solution icon of github
Feld "NAME" nicht gefunden Column "NAME" not found; SQL statement: SELECT LIMIT 0 5 DEFINITION_NAME, DEFINITION FROM STREAM_DEFINITIONS ORDER BY name DESC [42122-192]

Solution icon of googlegroups
Column LOWER not found; SQL statement: SELECT lower,upper,mixed from two [42122-100]

Solution icon of googlegroups
via Google Groups by Lee,YB, 1 year ago
Column PROBE_ID not found; SQL statement: select * from link_mouse430_2 where probe_id = 'a' [42122-75]

Solution icon of github
Column "COLOR" not found; SQL statement: SELECT * FROM color WHERE color LIKE 'A%' [42122-189]

Solution icon of stackoverflow
via Stack Overflow by Tom
, 8 months ago
Column "__VAL" not found; SQL statement: select __VAL from Integer [42122-191]

Solution icon of googlegroups
via Google Groups by Max Sidnin, 1 year ago
Column ID not found; SQL statement: SELECT Id, Name FROM GET_SOMETHING() [42122-109]

Solution icon of stackoverflow
Column "PASSWORD" not found; SQL statement: SELECT password FROM user WHERE 1 = 0 [42122-176]

Solution icon of googlegroups
via Google Groups by rb, 10 months ago
The owner protected this stack trace.

Solution icon of stackoverflow
Column "Chris" not found; SQL statement: insert into booking(booking_name) values("Chris") [42122-192]

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

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
2 times, 1 week ago
Once, 1 month ago
34 times, 1 month ago
143 more bugmates