topic Re: Transactions and read/write property in Alfresco Archive

Transactions and read/write property

calle — Tue, 20 Jan 2009 13:30:16 GMT

HiI have a scenario where nodeService.getProperty() and nodeService.setProperty() for the same property on the same node is executed inside a RetryingTransactionCallback:final RetryingTransactionHelper trxHelper = transactionService.getRetryingTransactionHelper();return trxHelper.doInTransaction(new

Re: Transactions and read/write property

lotharm — Tue, 20 Jan 2009 14:48:18 GMT

There is no mutex or semaphore mechanism build in. Instead, Alfresco uses the optimistic locking feature of Hibernate to avoid this kind of errors. One transaction will receive an exception on commit to indicate that the data has changed.

It would be very helpful to have a counter or sequencing mechanism build into Alfresco, indeed.

If you would like to avoid any concurrent updates, you would have to add some locking or recovering code.

Regards

Re: Transactions and read/write property

calle — Tue, 20 Jan 2009 15:56:26 GMT

Thanks
By that you mean that the optimistic locking feature of Hibernate will cause the transaction to throw an exception if the property value has changed when it is written? If I understand you correctly there is no exception thrown if the value is read by two threads simultaneously or written by one thread and read by anouther?

It is easy to implement standard java synchronization to resolve this, as long as you are not running on a clustered system… I do not know how to solve the synchornization in that case. What I had hoped for was that some underlying service in Hibernate or Alfresco would handle it.

Any ideas?

Re: Transactions and read/write property

mrogers — Tue, 20 Jan 2009 18:00:31 GMT

The behaviour of your code will be dependent upon your database's isolation level.

I think there is a fair chance that your code will work correctly, it's certainly worth you running some tests on your environment. The second transaction should retry after the concurrent update exception.

Sequential indexing is always problematic in distributed systems, and for this reason it is best avoided if possible.

Re: Transactions and read/write property

lotharm — Thu, 22 Jan 2009 19:19:08 GMT

Records Management could be a use case. The file plan requires almost always the generation of some unique id.
So a SequenceService may be a handy thing that could take of it at the database level.

Regards