This is everything i get in the H2 console: > SELECT * FROM ALARM_VISIBILITY where accountix=1; > > General error: "java.lang.NullPointerException"; SQL statement: > > SELECT * FROM ALARM_VISIBILITY where accountix=1 [50000-178] HY000/50000 >> (Hilfe) > > org.h2.jdbc.JdbcSQLException: General error: >> "java.lang.NullPointerException"; SQL statement: > > SELECT * FROM ALARM_VISIBILITY where accountix=1 [50000-178] > > at >> org.h2.message.DbException.getJdbcSQLException(DbException.java:344) > > at org.h2.message.DbException.get(DbException.java:167) > > at org.h2.message.DbException.convert(DbException.java:294) > > at org.h2.command.Command.executeQuery(Command.java:209) > > at org.h2.server.TcpServerThread.process(TcpServerThread.java:321) > > at org.h2.server.TcpServerThread.run(TcpServerThread.java:160) > > at java.lang.Thread.run(Unknown Source) > > Caused by: java.lang.NullPointerException > > at org.h2.mvstore.db.MVPrimaryIndex.getRow(MVPrimaryIndex.java:212) > > at org.h2.mvstore.db.MVTable.getRow(MVTable.java:367) > > at >> org.h2.mvstore.db.MVSecondaryIndex$MVStoreCursor.get(MVSecondaryIndex.java:491) >> > > at org.h2.index.IndexCursor.get(IndexCursor.java:261) > > at org.h2.table.TableFilter.getValue(TableFilter.java:898) > > at >> org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:187) > > at org.h2.command.dml.Select.queryFlat(Select.java:540) > > at org.h2.command.dml.Select.queryWithoutCache(Select.java:646) > > at org.h2.command.dml.Query.query(Query.java:323) > > at org.h2.command.dml.Query.query(Query.java:291) > > at org.h2.command.dml.Query.query(Query.java:37) > > at org.h2.command.CommandContainer.query(CommandContainer.java:91) > > at org.h2.command.Command.executeQuery(Command.java:197) > > ... 3 more > > >> at org.h2.engine.SessionRemote.done(SessionRemote.java:610) > > at org.h2.command.CommandRemote.executeQuery(CommandRemote.java:159) > > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:181) > > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:160) > > at org.h2.server.web.WebApp.getResult(WebApp.java:1391) > > at org.h2.server.web.WebApp.query(WebApp.java:1064) > > at org.h2.server.web.WebApp$1.next(WebApp.java:1026) > > at org.h2.server.web.WebApp$1.next(WebApp.java:1013) > > at org.h2.server.web.WebThread.process(WebThread.java:168) > > at org.h2.server.web.WebThread.run(WebThread.java:94) > > at java.lang.Thread.run(Unknown Source) > > > Best regards Am Dienstag, 13. Mai 2014 09:40:20 UTC+2 schrieb Noel Grandin: > > I think you cut a piece off the stacktrace, and we need that piece to > debug the problem :-) > > On 2014-05-13 08:49, David Pentzlin wrote: > > > > After adding a primary key to a table i cant use select with where > clause anymore (select without working fine). > > If i remove the primary the error is gone. > > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
