Hi, The trigger class must be available in the classpath of the database engine (when using the server mode, it must be in the classpath of the server).
Regards, Thomas On Tue, Sep 15, 2009 at 8:55 AM, Suresh <[email protected]> wrote: > > Hello Thomas, > > I created my own Trigger class named My_Trigger. and i have configured > this trigger as follows. > > <database-object> > <create> CREATE TRIGGER My_Trigger AFTER INSERT,UPDATE,DELETE > ON > INVOICE FOR EACH ROW CALL > "com.My_Trigger" </create> > <drop>DROP TRIGGER My_Trigger</drop> > </database-object> > > When i run the H2 data base with embeded mode, the trigger got created > in database perfectly. But when i am trying in server mode, i am > getting the following Error. > > 12:07:18,228 ERROR SchemaExport:274 - Unsuccessful: CREATE TRIGGER > My_Trigger AFTER INSERT,UPDATE,DELETE ON INVOICE FOR EACH ROW CALL > "com.My_Trigger" > > 12:07:18,229 ERROR SchemaExport:275 - Error creating or initializing > trigger My_Trigger object, class com.My_Trigger, cause: > org.h2.jdbc.JdbcSQLException: Class com.My_Trigger not found > [90086-115]; see root cause for details; SQL statement: > > Here i have run the server in server mode with the following url. > > db.jdbcUrl=jdbc:h2:tcp://localhost/~/finance/finance > > > and the trigger not created in the database. Here what should be the > mistake? Could you Please send me reply as soon as possible. > > Bye > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
