Re: Do triggers block?

2019-09-15 Thread Rick Hillegas
The statement.execute() method will not return until all triggered actions complete. If the trigger invokes a user-written java method, then the trigger will not finish executing until the method returns. All of the transactional work done by the statement operates within a savepoint. That incl

Do triggers block?

2019-09-15 Thread fkalim
Hi, I'm working with triggers in Derby and their order of execution is described in the document as given below. However, I wanted to clarify whether triggers are blocking e.g. if an AFTER trigger fires a function, does it block until the function has finished running? Order of execution When a d