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]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Daniel Rosenbaum, 1 year 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 Stack Overflow by Faisal
, 2 years ago
General error: "java.lang.RuntimeException: page[325] data leaf table:0 entries:16 parent:144 keys:[506, 508, 510, 512, 514, 516, 522, 528, 530, 532, 534, 545, 547, 549, 551, 553] offsets:[1936, 1825, 1713, 1601, 1488, 1374, 1262, 1150, 1038, 926, 815, 702, 589, 478, 366, 253] parent 144 expected 28" [50000-140]
via Google Groups by too, 2 years ago
General error: "java.lang.IllegalStateException: Corrupt page count -232 [1.4.177/3]"; SQL statement: COMMIT [50000-177]
via Google Groups by Unknown author, 4 months ago
General error: "java.lang.NullPointerException"; SQL statement: /* ExtendedConversationH2Dao._deletePartitipants */ DELETE FROM EXCONV_PARTICIPANTS_TBL WHERE EXCONVID=? [50000-192]
via GitHub by GoogleCodeExporter
, 9 months ago
Allgemeiner Fehler: "java.lang.NullPointerException" General error: "java.lang.NullPointerException"; SQL statement: UPDATE rclvalues SET timeend=1266929202937 WHERE state_id=7039 AND timeend IS null [50000-129]
via Google Groups by David Pentzlin, 2 years ago
General error: "java.lang.NullPointerException"; SQL statement: BACKUP TO 'data.zip' [50000-176]
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.(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.(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)
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 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)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.