Hi Guys, I'm trying to create a trigger on my h2 database but cant get it to work...
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?.. -- 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.
