posted 13 years ago
Hello,
If you want to do the audit log then you can either write the SQL or execute the Stored procedure that would update the audit table.
Call to this can be embedded before you call your SQLs or Stored procedures in your application.
In a better way of implementing it you can re-factor the code to invoke the SQL or SP in a helper class. This would help you to embed the audit call at one place.
I am not very certain if you have any readily available tool in iBatis that would do the audit logging for you.
I would suggest using the Trigger which would anyway reduce one database call from Data access layer.
hope this helps,
Amit