liquibase.exception.DatabaseException

org.h2.jdbc.JdbcSQLException: Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170]

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 web357

  • via JIRA by Lukas Eder, 1 year ago
    org.h2.jdbc.JdbcSQLException: Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170]
  • via JIRA by Lukas Eder, 1 year ago
    org.h2.jdbc.JdbcSQLException: Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170]
  • org.h2.jdbc.JdbcSQLException: Column "PASSWORD" not found; SQL statement: SELECT password FROM user WHERE 1 = 0 [42122-176]
  • Stack trace

    • liquibase.exception.DatabaseException: org.h2.jdbc.JdbcSQLException: Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170] at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:251) at liquibase.snapshot.DatabaseSnapshotGeneratorFactory.createSnapshot(DatabaseSnapshotGeneratorFactory.java:69) at org.jooq.test.liquibase2jooq.Adapters.before(Adapters.java:63) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27) at org.junit.runners.ParentRunner.run(ParentRunner.java:236) at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197) Caused by: org.h2.jdbc.JdbcSQLException: Feld "WHITE" nicht gefunden Column "WHITE" not found; SQL statement: SELECT WHITE SPACE FROM PUBLIC.X WHERE 1 = 0 [42122-170] at org.h2.message.DbException.getJdbcSQLException(DbException.java:329) at org.h2.message.DbException.get(DbException.java:169) at org.h2.message.DbException.get(DbException.java:146) at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:141) at org.h2.expression.Alias.optimize(Alias.java:47) at org.h2.command.dml.Select.prepare(Select.java:799) at org.h2.command.Parser.prepareCommand(Parser.java:218) at org.h2.engine.Session.prepareLocal(Session.java:414) at org.h2.engine.Session.prepareCommand(Session.java:363) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:70) at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.isColumnAutoIncrement(JdbcDatabaseSnapshotGenerator.java:842) at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.readColumns(JdbcDatabaseSnapshotGenerator.java:369) at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.createSnapshot(JdbcDatabaseSnapshotGenerator.java:244) ... 17 more

    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

    4 times, 1 month ago
    2 times, 3 months ago
    Once, 9 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    143 more bugmates