Eclipse Community Forums: EclipseLink

Help

Home

Home » Eclipse Projects » EclipseLink » Transaction logging

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

Transaction logging [message #780780]

Thu, 19 January 2012 11:03

Thomas

Messages: 9
Registered: December 2011

Junior Member

Hi,

I want to log each transaction in the following way:

For each entity inserted/deleted/updated between transaction.begin() and transaction.commit() a transaction-id should be written both into the history table corresponding to the changed entity and into a "transaction-log-table". An entry in the transaction-log-table should also include e.g. a list (as string) of the tables/entities involved in the transaction.

I have already created a history customizer but have no idea how to handle the transaction (not entity) specific logging.

Any help would be very appreciated!

Thomas

Report message to a moderator

Re: Transaction logging [message #780841 is a reply to message #780780]

Thu, 19 January 2012 15:06

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

It might be easiest to create an Entity that maps to your transaction log table and persist a log object with each transaction.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: Transaction logging [message #780847 is a reply to message #780841]

Thu, 19 January 2012 15:47

Thomas

Messages: 9
Registered: December 2011

Junior Member

Hi James,

thanks for your answer. I thought of this too but the following questions arise:

How to ensure a "transaction-log entity" is created and persisted with every transaction? Is it possible to listen to transaction "events" (something like @PreCommit) or do I have to write something like for example a transaction decorator which handles the additional steps on commit (and furthermore an entitymanager which delivers such a decorated transaction on getTransaction())? My goal is to hide the details of this transaction logging from a user of the entitymanager.

How to determine the entities/tables affected by the actual transaction so this information can be stored within the transaction-log entity?

How to write the transaction id into the (from history policy) newly created row within the particular history table of each other entity changed in the actual transaction?

Best regards

Thomas

Report message to a moderator