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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.