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


Solutions on the web

Solution icon of stackoverflow
via Stack Overflow by Stephan
, 8 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 stackoverflow
Column "PASSWORD" not found; SQL statement: SELECT password FROM user WHERE 1 = 0 [42122-176]

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

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

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

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

Solution icon of stackoverflow
Column "NAME_C" not found; SQL statement: SELECT name AS "name_c" FROM users ORDER BY lower(name_c) [42122-163]

Solution icon of web
via JIRA by Lukas Eder, 1 year ago
Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170]

Solution icon of web
via JIRA by Lukas Eder, 1 year ago
Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170]

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
4 times, 5 days ago
Once, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 week ago
148 more bugmates