Hello All,
We are using the CMP 2.0 EJBs and Container Managed Security (thinking that its going to simplify the coding and possibly time to market fast ).
One of our requirement is that when ever there is a modification in some of the select fields of some select tables we have to audit them means we have to insert this modified fields old_value and new_value along with the modifiers login ID.
And also Each table has Updated_By and Updated_Date, we have to update these values for each row when ever there is a update for any of the fileds in that particular row.
What could be the best strategy for this kind of problems?
Using Oracle Triggers? Or is to good to code the required fileds logging functionality in the CMP
EJB?
If we select Oracle Triggers, The update for a row should always include the updated_by value how do we make sure that we have the setup before the EJB makes a call to DB to update the row, the question is how do we find that there is any modification for any of the fileds in the CMP EJB and also how do we make sure that EJB is going to write to DB (because its not guareented that all calls to ejbStore are going to updated the DB , the EJB vendor may select not to update DB if there are no changes in the CMP values )
All sorts of suggestions comments welcome!!!
Thank you
Mallik
