org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: CREATE VIEW application.OccurrenceAOtherEndophthalmitis40_precondition_391 AS SELECT t150.*, o1.ido1 FROM application.OccurrenceAOtherEndophthalmitis40 t150 JOIN application.OccurrenceACataractSurgery5 o1 ON t150.patient_id = o1.patient_id WHERE t150.negation_code_id IS NULL AND t150.effective_time_end < o1.effective_time_start [50000-192]

Google Groups | Daniel Rosenbaum | 5 months ago
  1. 0

    Multi-Threading issues

    Google Groups | 5 months ago | Daniel Rosenbaum
    org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: CREATE VIEW application.OccurrenceAOtherEndophthalmitis40_precondition_391 AS SELECT t150.*, o1.ido1 FROM application.OccurrenceAOtherEndophthalmitis40 t150 JOIN application.OccurrenceACataractSurgery5 o1 ON t150.patient_id = o1.patient_id WHERE t150.negation_code_id IS NULL AND t150.effective_time_end < o1.effective_time_start [50000-192]
  2. 0

    Inserting data into a H2 Database Table

    Stack Overflow | 3 years ago | Oliver Muchai
    org.h2.jdbc.JdbcSQLException: Column "DATABASE" not found; SQL statement: INSERT INTO MYLOVELYSTUDENTS VALUES (123456789, 'Zara', 'Ali', 18, database) [42122-173]
  3. 0

    long not accepted as data type

    GitHub | 2 years ago | GoogleCodeExporter
    org.h2.jdbc.JdbcSQLException: Unknown data type: ); SQL statement: CREATE TABLE test (id LONG) [50004-113]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Mitglieder löschen - Fehlermeldung - JVerein

    jverein.de | 6 months ago
    org.h2.jdbc.JdbcSQLException: Referentielle Integrität verletzt: FKABRECHNUNG1: PUBLIC.ABRECHNUNG FOREIGN KEY(MITGLIED) REFERENCES PUBLIC.MITGLIED(ID) Referential integrity constraint violation: FKABRECHNUNG1: PUBLIC.ABRECHNUNG FOREIGN KEY(MITGLIED) REFERENCES PUBLIC.MITGLIED(ID); SQL statement: delete from MITGLIED where ID = 1760 [23003-117]
  6. 0

    I had org.h2.jdbc.JdbcSQLException on update 1.5 to 1.6

    GitHub | 3 years ago | teaplanet
    org.h2.jdbc.JdbcSQLException: テーブル "ACCOUNT" はすでに存在します Table "ACCOUNT" already exists; SQL statement: CREATE TABLE ACCOUNT( USER_NAME VARCHAR(100) NOT NULL, MAIL_ADDRESS VARCHAR(100) NOT NULL, ... [42101-171]

    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. java.lang.NullPointerException

      No message provided

      at org.h2.engine.Session.popSubQueryInfo()
    2. H2 Database Engine
      JdbcStatement.executeUpdate
      1. org.h2.engine.Session.popSubQueryInfo(Session.java:201)
      2. org.h2.index.ViewIndex.prepareSubQuery(ViewIndex.java:176)
      3. org.h2.index.ViewIndex.getQuery(ViewIndex.java:309)
      4. org.h2.index.ViewIndex.<init>(ViewIndex.java:102)
      5. org.h2.table.TableView.getBestPlanItem(TableView.java:248)
      6. org.h2.table.TableFilter.getBestPlanItem(TableFilter.java:220)
      7. org.h2.table.Plan.calculateCost(Plan.java:123)
      8. org.h2.command.dml.Optimizer.testPlan(Optimizer.java:183)
      9. org.h2.command.dml.Optimizer.calculateBruteForceAll(Optimizer.java:112)
      10. org.h2.command.dml.Optimizer.calculateBestPlan(Optimizer.java:83)
      11. org.h2.command.dml.Optimizer.optimize(Optimizer.java:242)
      12. org.h2.command.dml.Select.preparePlan(Select.java:1014)
      13. org.h2.command.dml.Select.prepare(Select.java:878)
      14. org.h2.command.Parser.prepare(Parser.java:239)
      15. org.h2.engine.Session.prepare(Session.java:525)
      16. org.h2.engine.Session.prepare(Session.java:512)
      17. org.h2.table.TableView.compileViewQuery(TableView.java:105)
      18. org.h2.table.TableView.initColumnsAndTables(TableView.java:156)
      19. org.h2.table.TableView.init(TableView.java:98)
      20. org.h2.table.TableView.<init>(TableView.java:65)
      21. org.h2.command.ddl.CreateView.update(CreateView.java:116)
      22. org.h2.command.CommandContainer.update(CommandContainer.java:98)
      23. org.h2.command.Command.executeUpdate(Command.java:258)
      24. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
      25. org.h2.message.DbException.get(DbException.java:168)
      26. org.h2.message.DbException.convert(DbException.java:295)
      27. org.h2.command.Command.executeUpdate(Command.java:266)
      28. org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:130)
      29. org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:115)
      29 frames
    3. HikariCP-java6
      HikariProxyStatement.executeUpdate
      1. com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
      2. com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
      2 frames
    4. Spring Framework
      JdbcTemplate.update
      1. org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:523)
      2. org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:520)
      3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404)
      4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:534)
      4 frames