Audit details of Collection Changes

For questions and postings not covered by the other forums
alanvl
Posts: 29
Joined: Fri Aug 14, 2009 9:16 pm

Audit details of Collection Changes

Postby alanvl » Thu Aug 26, 2010 10:05 pm

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?

User avatar
Dr Danyo
Posts: 56
Joined: Fri Aug 21, 2009 8:59 am

Re: Audit details of Collection Changes

Postby Dr Danyo » Fri Aug 27, 2010 3:35 am

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.

GerardO'Brien
Posts: 12
Joined: Tue Jul 07, 2009 9:49 am

Re: Audit details of Collection Changes

Postby GerardO'Brien » Fri Aug 27, 2010 10:08 am

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.

alanvl
Posts: 29
Joined: Fri Aug 14, 2009 9:16 pm

Re: Audit details of Collection Changes

Postby alanvl » Fri Aug 27, 2010 10:40 pm

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.


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 18 guests