We are working in a project using J2EE technologies along with Oracle 8 (and 9 in the future) as our database system.
When using logical deletes of registries and updates, we wanted to use triggers in order to ensure data integrity, and leaving this work to database system. We don't want to delegate this work on our EJBs, because we think that our system's behaviour would be affected. Furthermore, we could retrive data that could be changed by other processes, etc.
Is it correct to use triggers before or after update for every table, without charging them too much or should we do that work on our EJBs?