Eclipse Community Forums: EclipseLink

Home » Eclipse Projects » EclipseLink » audit tracking(audit tracking business object life cycle with life cycle change listener)

Show: Today's Messages :: Show Polls :: Message Navigator

audit tracking [message #523584]

Fri, 26 March 2010 19:18

No real name
Messages: 3
Registered: March 2010

Junior Member

Hi,
Basically i have to track life cycle status changes of business objects and log from which status an object has migrated to which status. We do not want to track every change in data, but only those changes that have the targeted business value. We have to store this history for years and display it in appropriate screens.

In openJPA, i can configure restoreState to obtain the old state of the object. How could i achieve this with EclipseLink?

Will the life cycle change listeners for this purpose cause any performance deterioration? Our Architects advised that we solve it in Java rather than with PL/SQL triggers.What other solutions are available for audit tracking?

Could you please give me links to EclipseLink examples for audit tracking?

Thank you.

Report message to a moderator

Re: audit tracking [message #523610 is a reply to message #523584]

Sat, 27 March 2010 03:31

Tom Eugelink
Messages: 801
Registered: July 2009

Senior Member

> In openJPA, i can configure restoreState to obtain the old state of the
> object. How could i achieve this with EclipseLink?

I know Eclipselink has a build-in function for keeping history, but that only does whole records, not single fields. But you can a.o. derive the history status changes from that table.

Eclipselink also has a fine grained event structure (similar to db triggers), so you could put in code there to store the status changes.

But I would simply go for the setStatus method. I assume you have an "HistoricalStatus" many-to-one entity bound to the actual entity, you could simply enhance the setStatus method to something like (I quickly put this together as an example):

public void setStatus(int status)
{
if (iLastHistoricalStatus == null || iLastHistoricalStatus.getStatus() != status)
{
if (iLastHistoricalStatus != null) removeHistoricalStatus(iLastHistoricalStatus);
iLastHistoricalStatus = new HistoricalStatus(iStatis);
addHistoricalStatus(iLastHistoricalStatus);
}
iStatus = status;
}
@JpaAnnotation...
int iStatus = ...
volatile HistoricalStatus iLastHistoricalStatus = null;

This will add the last set status value as an entity to the actual entity.

Report message to a moderator

Re: audit tracking [message #523917 is a reply to message #523584]

Mon, 29 March 2010 15:41

James Sutherland
Messages: 1844
Registered: July 2009

Senior Member

In addition to JPA events EclipseLink has DescriptorEvents that are raised in more operations, and with additional information. There are events for preInsert/postInsert/aboutToInsert/Update/Delete. Each event has an ObjectChangeSet that contains the changes.

See,
DescriptorEventListener

and,
DescriptorEvent and ObjectChangeSet

You can also get a list of changes from the EclipseLink UnitOfWork, and can get the previous state of a object using getBackupClone (provided deferred change tracking is used).

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:	Initialize EclipseLink at runtime
Next Topic:	Elements of List in @OneToMany with @OrderColumn are not being sorted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 26 02:57:09 EDT 2013