On Thursday, March 20, 2014 7:48:12 PM UTC+8, Vonmist wrote: > > Hi all, > > I am currently using h2 version 1.3.174 and faced this error when i am > working on Trigger class whereby a UPDATE statement is at the fire() method. > I have searched the net and was told h2 v1.3.174 shouldnt have this > problem but even when i changed back to 1.3.174, the error still surface. > Please Help. > > > Thanks > > org.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException"; SQL statement: UPDATE `Log` changeLog = ? WHERE test = ? AND name = ? [50000-174] at org.h2.message.DbException.getJdbcSQLException(DbException.java:332) at org.h2.message.DbException.get(DbException.java:161) at org.h2.message.DbException.convert(DbException.java:284) at org.h2.schema.TriggerObject.fireRow(TriggerObject.java:215) at org.h2.table.Table.fireRow(Table.java:916) at org.h2.table.Table.fireAfterRow(Table.java:907) at org.h2.command.dml.Update.update(Update.java:150) at org.h2.command.CommandContainer.update(CommandContainer.java:79) at org.h2.command.Command.executeUpdate(Command.java:253) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:140) at com.auctorizium.database.server.TestTrigger.computeConsolidatedChangeLog(TestTrigger.java:109) at com.auctorizium.database.server.TestTrigger.fire(TestTrigger.java:51) at org.h2.schema.TriggerObject.fireRow(TriggerObject.java:201) at org.h2.table.Table.fireRow(Table.java:916) at org.h2.table.Table.fireAfterRow(Table.java:907) at org.h2.command.dml.Insert.insertRows(Insert.java:129) at org.h2.command.dml.Insert.update(Insert.java:86) at org.h2.command.CommandContainer.update(CommandContainer.java:79) at org.h2.command.Command.executeUpdate(Command.java:253) at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:154) at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:140) at com.auctorizium.database.server.DBWriteSingleton.updateSubordinate(DBWriteSingleton.java:339) at com.auctorizium.database.wrapper.ServerDBWrite.updateSubordinate(ServerDBWrite.java:75) at com.auctorizium.server.Main.main(Main.java:86) Caused by: java.lang.NullPointerException at com.auctorizium.database.server.TestTrigger.fire(TestTrigger.java:41) at org.h2.schema.TriggerObject.fireRow(TriggerObject.java:201) ... 21 more
-- 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.
