Stanley Bradbury wrote:
Hi Alex -
The answer depends on the type of trigger. A transaction occurs
within a single connection. For simple, single SQL statement triggers
the trigger activities are part of the transaction (execute within the
context of the current connection) and are rolled back. Should a SQL
statement trigger fail it raises an exception that is passed to the
calling routine. This is covered here:
http://db.apache.org/derby/docs/dev/devguide/cdevspecial49460.html
thank you. that answers my question.
