Hi, The trigger class needs to be public, and in the classpath where the database is running. When using the server mode, the database is running on the server.
Regards, Thomas On Thursday, December 26, 2013, Vonmist wrote: > Hi, > > Thanks i will try it out. > By the way, is trigger about to be used in server mode? When i tried > running > my database in server mode and another application connect to it and do a > delete/update/insert statement, this error came out. > > Exception in thread "main" org.h2.jdbc.JdbcSQLException: Error creating or > initializing trigger "AFTERTRIGGER" object, class > "triggertest.TriggerTryout$MyTrigger", cause: "org.h2.message.DbException: > Class ""triggertest.TriggerTryout$MyTrigger"" not found [90086-172]"; see > root cause for details; SQL statement: > > If i close the one of the connection to the database, the sql statement > will > run properly with the trigger being activated. Do you by any chance know > whats wrong? > > > > -- > View this message in context: > http://h2-database.66688.n3.nabble.com/h2-Is-there-any-way-a-trigger-can-be-invoked-when-a-new-table-is-created-tp4028100p4028130.html > Sent from the H2 Database mailing list archive at Nabble.com. > > -- > 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] <javascript:;>. > To post to this group, send email to > [email protected]<javascript:;> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- 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/groups/opt_out.
