David Warnock wrote:
Hi,
We are using Optimistic integer locking on some tables. However, we want to do the incrementing in dbms triggers. Then we can have a dbms trigger that throws an exception if the locking column has changed (ie another user has updated the row). If the column is unchanged then the trigger increments it.
This makes it simpler to have multiple tools/languages updating the dbms.
I agree!
Where should I look in OJB to keep the optimistic locking checks but for OJB not to update the version column.
This is a tough question.
The current OL solution is tightly linked into the OJB core. It is currently not pluggable.
But I assume it will be possible to integrate user defined mechanisms without too much pain.
cheers, Thomas
Thanks
Dave
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
