Web application and a trigger

["Judy Osell" <judyosell@xxxxxxxxxxxxx>]

I'm working with an application that updates tables via the web.  The web
application is using commitment control to back out any updates/inserts to
the table if an error is found during validation.  I've never seen
commitment control used in this way.  Is this a common use of commitment
control?  

 

To make it more complicated there is a trigger on the file that the web
application is using.  Is there any way the web application and the trigger
can share the same commitment control?  I don't want the trigger to run if
the web application does a roll back.  The trigger is activated when a row
is inserted into the table and a program is submitted to batch to continue
processing.  The batch program also uses commitment control. 

 

 

Judy Osell