org.h2.jdbc.JdbcSQLException: Column "TEST_TABLE.ID" not found; SQL statement: ALTER TABLE TEST_TABLE ADD COLUMN NEW_COLUMN BIGINT [42122-192]

Google Groups | rb | 4 months ago
  1. 0

    Constraint check causes error on alter

    Google Groups | 4 months ago | rb
    org.h2.jdbc.JdbcSQLException: Column "TEST_TABLE.ID" not found; SQL statement: ALTER TABLE TEST_TABLE ADD COLUMN NEW_COLUMN BIGINT [42122-192]
  2. 0

    JdbcSQLException using GROUP BY on h2 Database

    Stack Overflow | 3 years ago | ETN
    org.h2.jdbc.JdbcSQLException: Column "ACTOR.ID" must be in the GROUP BY list; SQL statement: SELECT ACTOR.ID, ACTOR.PERSONID FROM ACTOR GROUP BY PERSONID [90016-161]
  3. 0

    H2 - General error: "java.lang.NullPointerException" [50000-182]

    Stack Overflow | 2 years ago | Lucas Wa
    org.h2.jdbc.JdbcSQLException: Błąd ogólny: "java.lang.NullPointerException" General error: "java.lang.NullPointerException" [50000-182]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    New issue with numeric scale in decimal data type

    Google Groups | 6 years ago | dariof
    org.h2.jdbc.JdbcSQLException: Invalid value "32767" for parameter "scale (precision = 1)"; SQL statement: CREATE MEMORY TABLE PUBLIC.T1_COPY_2_0( SALARY DECIMAL(1, 32767), F1 INT ) AS SELECT SALARY, NULL FROM PUBLIC.T1 [90008-155]
  6. 0

    Exception when opening DB after forced shutdown (1.3.176)

    Google Groups | 3 years ago | too
    org.h2.jdbc.JdbcSQLException: Column count does not match; SQL statement: -- page 24269: data leaf (last) parent: 24276 table: 206 entries: 2 columns: 68 INSERT INTO O_206 VALUES('CFR:2014:181', 'admin', 'EUR:11/04/2012', '1150-008', 'CFR', '100', '', DATE '2014-06-25', DATE '2014-06-25', DATE '2014-06-25', DATE '2014-06-25', DATE '2014-06-25', DATE '2014-06-25', 'admin', 0, 'CL:987', 0, '', NULL, 'zA5BuP3HRVU9P5e8c1jdoQMlwBjHNLKnabmhkfUWUBwkcuMLsqUzbG0PMSVly+JM4TuSupWcyFmk0+Kv6UKA3DD0qziXI/xI2AU75bR0LCG2V8/Ly+HgxA/3Lh1MA5nJaGP6bf9FcHkDr5MTnLL3luNkQN72c7uVgw1P4dl/gcQ=', 2, TIME '16:10:45.39', TIME '16:05:45', TIME '16:53:17.233', '', STRINGDECODE('Av. Almirante Reis, N\u00ba 21 \u2013 3\u00ba Esq.'), 'Lisboa', '', '', '101', 'AE', 'EUR', STRINGDECODE('Av. Almirante Reis, N\u00ba 21 \u2013 3\u00ba Esq.'), 'CFR:2014:181', '252 260 953', 'Pamela Uyara Ferreira de Lima', '', 181, STRINGDECODE('FORM=Presta\u00e7\u00f5es de Servi\u00e7os de Forma\u00e7\u00e3o Profissional'), 0.00, 0.000000, 0.000000, 'CFR:2014', '702', 'CFR', 'CL', 75.000000, 75.000000, 0.000000, 0.000000, 0.000000, 75.000000, 0.000000, 0.000000, 0.000000, 75.000000, '001', 0.000000, 1, TIME '16:05:45', '', 'PT', '', 75.000000, 0, NULL, 0, NULL) [21002-176]

    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 "TEST_TABLE.ID" not found; SQL statement: ALTER TABLE TEST_TABLE ADD COLUMN NEW_COLUMN BIGINT [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.expression.Comparison.optimize(Comparison.java:180)
      6. org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:130)
      7. org.h2.command.dml.Select.prepare(Select.java:855)
      8. org.h2.engine.Session.optimizeQueryExpression(Session.java:232)
      9. org.h2.expression.Subquery.optimize(Subquery.java:72)
      10. org.h2.expression.Comparison.optimize(Comparison.java:178)
      11. org.h2.command.ddl.AlterTableAddConstraint.tryUpdate(AlterTableAddConstraint.java:191)
      12. org.h2.command.ddl.AlterTableAddConstraint.update(AlterTableAddConstraint.java:77)
      13. org.h2.command.ddl.AlterTableAlterColumn.execute(AlterTableAlterColumn.java:488)
      14. org.h2.command.ddl.AlterTableAlterColumn.cloneTableStructure(AlterTableAlterColumn.java:424)
      15. org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColumn.java:254)
      16. org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:177)
      17. org.h2.command.CommandContainer.update(CommandContainer.java:98)
      18. org.h2.command.Command.executeUpdate(Command.java:258)
      19. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:184)
      20. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
      21. org.h2.server.web.WebApp.getResult(WebApp.java:1388)
      22. org.h2.server.web.WebApp.query(WebApp.java:1061)
      23. org.h2.server.web.WebApp$1.next(WebApp.java:1023)
      24. org.h2.server.web.WebApp$1.next(WebApp.java:1010)
      25. org.h2.server.web.WebThread.process(WebThread.java:164)
      26. org.h2.server.web.WebThread.run(WebThread.java:89)
      26 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Unknown Source)
      1 frame