Re: [h2] Having DbException Syntax error in SQL statement defining a H2 trigger

Hi, I'm not sure why, but it looks like inner classes are not supported right now. I get: Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at

Re: [h2] Having DbException Syntax error in SQL statement defining a H2 trigger

Hi Noel, thanks for the reply. This is the full stacktrace of the error SQL Error [90043] [90043]: Error creating or initializing trigger "MY_TRIGGER" object, class "..source..", cause: "org.h2.message.DbException: Syntax error in SQL statement "" org.h2.api.Trigger create() {

Re: [h2] Having DbException Syntax error in SQL statement defining a H2 trigger

what does the rest of the exception trace look like? -- 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

[h2] Having DbException Syntax error in SQL statement defining a H2 trigger

Hi, I'm defining a H2 trigger with the following command CREATE TRIGGER MY_TRIGGER BEFORE INSERT ON MY_TABLE AS $$ org.h2.api.Trigger create() { return new org.h2.api.Trigger() { @Override public void remove() throws SQLException { }