Re: Recover After Crash

In Article 8pq8c6$am7$14$1_at_news.t-online.com, Carl Rosenberger wrote:

>> So they will see modifications (potentially to other tables)
>> only after user will close document (transaction). This is
>> not appropriate. We need to modify other tables and other
>> people to see our modifications while document is open -
>> all this in *one* connection.

Thats why I am not into using it, I want to play safe.

> You could also use a locking mechanism outside of the database server, if
> you want to spare resources:
> Create a file on the server with an appropriate naming convention and open
> it for readwrite. The lock should be released instantly on any crash.

This method we currently use. I was hoping there is a way to solve this problem at database level only.

-- 
Mike Kluev.

PS. Remove "-delete-." part of my e-mail address to reply.