Page 1 of 1

Audit details of Collection Changes

Posted: Thu Aug 26, 2010 10:05 pm
by alanvl
I am trying to retrieve change details for collections. I have successfully used the JadeAuditAccess class to get other audit changes but collection changes have eluded me – information like: Oid of Object added; Oid of Object removed; primitive inserted at index; primitive removed at index.
Anyone able to help out?

Re: Audit details of Collection Changes

Posted: Fri Aug 27, 2010 3:35 am
by Dr Danyo
Hi Alanvl,

What version of JADE are you using?

We hit this issue back in 2008 (things may have moved on since then) and ended up working around it by implementing application logic to manually track the changes to the contents of the collections.

- regards Dr Danyo.

Re: Audit details of Collection Changes

Posted: Fri Aug 27, 2010 10:08 am
by GerardO'Brien
Database auditing is a mechanism used by the database engine to restore state in the event of failure (transaction or system). In general, when a database record update is audited, information that permits construction of either the before image, or the after image, is written to the audit trail. Modifications to any object, including collection blocks, are sent as complete images to the database in transaction commit. The description of individual collection operations such as add or remove entry are not accessible from a database journal.

Re: Audit details of Collection Changes

Posted: Fri Aug 27, 2010 10:40 pm
by alanvl
I'm using Jade 6.3.05
Thanks Gerard - understand what you are saying - but it would be good to know what information was available about changes to collection in the and how to access it. The before and after images related to the change are null.