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]

Solutions on the web1514

  • via Google Groups by Daniel Rosenbaum, 11 months ago
    General error: "java.lang.NullPointerException"; SQL statement: CREATE VIEW application.OccurrenceAOtherEndophthalmitis40_precondition_391 AS SELECT t150.*, o1.ido1 FROM application.OccurrenceAOtherEndophthalmitis40 t150 JOIN
  • via h2database.com by Unknown author, 9 months ago
    Timeout trying to lock table "SYS"; SQL statement: CREATE VIEW INVOICE_DETAIL_VIEW124 as SELECT DTL.* FROM INVOICE_VIEW124 INV JOIN INVOICE_DETAIL_VIEW DTL ON INV.INVOICE_ID = DTL.INVOICE_ID WHERE DESCRIPTION='TEST' [50200-192]
  • Allgemeiner Fehler: "java.lang.NullPointerException" General error: "java.lang.NullPointerException"; SQL statement: SELECT prp1.subject AS left, prp2.subject AS right, MIN(prp1.id) AS sourceId1, 'objectPropertyAssertion' AS sourceTable1, MIN(prp1
  • Stack trace

    • 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] at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) at org.h2.message.DbException.get(DbException.java:168) at org.h2.message.DbException.convert(DbException.java:295) at org.h2.command.Command.executeUpdate(Command.java:266) at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:130) at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:115) at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120) at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java) at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:523) at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:520) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:534) Caused by: java.lang.NullPointerException at org.h2.engine.Session.popSubQueryInfo(Session.java:201) at org.h2.index.ViewIndex.prepareSubQuery(ViewIndex.java:176) at org.h2.index.ViewIndex.getQuery(ViewIndex.java:309) at org.h2.index.ViewIndex.<init>(ViewIndex.java:102) at org.h2.table.TableView.getBestPlanItem(TableView.java:248) at org.h2.table.TableFilter.getBestPlanItem(TableFilter.java:220) at org.h2.table.Plan.calculateCost(Plan.java:123) at org.h2.command.dml.Optimizer.testPlan(Optimizer.java:183) at org.h2.command.dml.Optimizer.calculateBruteForceAll(Optimizer.java:112) at org.h2.command.dml.Optimizer.calculateBestPlan(Optimizer.java:83) at org.h2.command.dml.Optimizer.optimize(Optimizer.java:242) at org.h2.command.dml.Select.preparePlan(Select.java:1014) at org.h2.command.dml.Select.prepare(Select.java:878) at org.h2.command.Parser.prepare(Parser.java:239) at org.h2.engine.Session.prepare(Session.java:525) at org.h2.engine.Session.prepare(Session.java:512) at org.h2.table.TableView.compileViewQuery(TableView.java:105) at org.h2.table.TableView.initColumnsAndTables(TableView.java:156) at org.h2.table.TableView.init(TableView.java:98) at org.h2.table.TableView.<init>(TableView.java:65) at org.h2.command.ddl.CreateView.update(CreateView.java:116) at org.h2.command.CommandContainer.update(CommandContainer.java:98) at org.h2.command.Command.executeUpdate(Command.java:258) ... 12 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

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.