Hi Brish, I don't see that HSQLDB supports having the Java within the database for use by triggers.
The first link you sent says "A trigger action can be written as a Java class that implements the org.hsqldb.Trigger interface" and gives and example of a trigger that uses the class: create trigger trigbur before update of c1, c2, c3 on testtrig referencing new row as newrow for each row when (newrow.c2 is not null) call "org.hsqldb.test.TriggerClass" ... but I don't see how you can define "org.hsqldb.test.TriggerClass" apart from by putting a compiled Java class on the classpath. I certainly cannot see an example of it in those links -- am I missing something? Thanks Kerry On Thu, Jun 24, 2010 at 4:08 PM, Brish <[email protected]> wrote: > On Jun 23, 8:50 pm, Kerry Sainsbury <[email protected]> wrote: > > I've actually got this mostly implemented, but before I spend any more > time > > on it I thought I'd better see if anybody > > thought this added any value -- and if other databases did anything > similar > > in a nicer way. > > I prefer the way HSQLDB 2.0 does it: > http://hsqldb.org/doc/2.0/guide/triggers-chapt.html > http://hsqldb.org/doc/2.0/guide/sqlroutines-chapt.html > > Brish > > -- > 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]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- 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.
