db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Schatten <ala...@gmx.at>
Subject Re: Triggers and Transaction behaviour
Date Sat, 12 Aug 2006 14:18:27 GMT
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.

View raw message