Thanks!... Trying to test now.... I created a Trigger class that implements the Trigger interface. I compiled this to a class file and into a jar and placed the jar in the same place as my h2 jar.
i run the server as follows (jars are inside the drivers directory) java -cp "%my_app%\drivers\*" org.h2.tools.Server -tcp -web I then try to run the following trigger on my database after opening up the web console CREATE TRIGGER MYTRIGGER AFTER INSERT ON ADDRESS FOR EACH ROW CALL"Triggerh2" and get the following error, Error creating or initializing trigger "MYTRIGGER" object, class "Triggerh2", cause: "org.h2.message.DbException: Class ""Triggerh2"" not found [90086-176]"; see root cause for details; SQL statement: CREATE TRIGGER MYTRIGGER AFTER INSERT ON ADDRESS FOR EACH ROW CALL"Triggerh2" [90043-176] <http://9.162.150.89:8082/query.do?jsessionid=8f724cae71b306ba7bb4da12e01cdf70#> 90043/90043 (Help) <http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90043> What am i doing worng here?... how is the jar not on the classpath? On Tuesday, 14 April 2015 14:11:04 UTC+1, Noel Grandin wrote: > > > > On 2015-04-14 02:35 PM, blu10 wrote: > > ok, sorry for confusion... > > maybe i miss understood but i thought i could add triggers to each table > and have an trigger implemented to reveal the > > inserted info... is this not possible > > > > That you can do. > -- 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.
