Hi Noel The exception trace is as shown from previous post.
Thanks On Thursday, March 20, 2014 8:06:25 PM UTC+8, Vonmist wrote: > > > > 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.
