http://www.theserverside.com Most recent forum messages en Jive Forums Silver 5.5.30 (www.jivesoftware.com) Tue, 21 May 2013 08:40:44 -0400 http://www.theserverside.com/discussions/thread.tss?thread_id=29510
Lock Table: id, record_id, user_id, created, last_modified

When a user wants to edit data they throw a record in the lock...]]> Thu, 21 Oct 2004 10:08:12 -0400 Thu, 21 Oct 2004 10:08:12 -0400 Thu, 21 Oct 2004 10:08:12 -0400 Oct 21, 2004 bruce goldstein 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29510 Wed, 20 Oct 2004 18:46:49 -0400 Wed, 20 Oct 2004 18:46:49 -0400 Wed, 20 Oct 2004 18:46:49 -0400 Oct 20, 2004 Duncan Mills 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29510 I'd say just the opposite, let the database handle the locking.
Unfotunately, this is NOT "Explicit Locking" by application. Row levels locks in a web application are to be handled automatically by the DB and not...]]> Wed, 20 Oct 2004 02:51:08 -0400 Wed, 20 Oct 2004 02:51:08 -0400 Wed, 20 Oct 2004 02:51:08 -0400 Oct 20, 2004 Sanjaya Ganesh 1 http://www.theserverside.com/discussions/thread.tss?thread_id=29510
i come from a background using different dbms's and mysql doesn't offer triggers so i'm always looking for non-db solutions first. the OR layer seems like the most general solution

luckily i hardly develop...]]> Wed, 20 Oct 2004 01:10:20 -0400 Wed, 20 Oct 2004 01:10:20 -0400 Wed, 20 Oct 2004 01:10:20 -0400 Oct 20, 2004 joseph yi 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29510 My suggestion is dont use explicit locks. Explicit row locks in web applications can cause chaos. Imagine, I opening the record and go home for the day leaving the browser open :-).That's a pretty dangerous suggestion, I'd say...]]> Tue, 19 Oct 2004 19:08:21 -0400 Tue, 19 Oct 2004 19:08:21 -0400 Tue, 19 Oct 2004 19:08:21 -0400 Oct 19, 2004 Duncan Mills 3 http://www.theserverside.com/discussions/thread.tss?thread_id=29510 Tue, 19 Oct 2004 16:03:37 -0400 Tue, 19 Oct 2004 16:03:37 -0400 Tue, 19 Oct 2004 16:03:37 -0400 Oct 19, 2004 joseph yi 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29510
This is a standard isolation issue with any DB application. Normally, there are two ways in which you can address this:

(1) Allow the users to manually handle this. Let any number of people update it, it is their responsibility to...]]> Tue, 19 Oct 2004 04:23:43 -0400 Tue, 19 Oct 2004 04:23:43 -0400 Tue, 19 Oct 2004 04:23:43 -0400 Oct 19, 2004 Sanjaya Ganesh 5 http://www.theserverside.com/discussions/thread.tss?thread_id=29510 Mon, 18 Oct 2004 19:06:44 -0400 Mon, 18 Oct 2004 19:06:44 -0400 Mon, 18 Oct 2004 19:06:44 -0400 Oct 18, 2004 joseph yi 0 http://www.theserverside.com/discussions/thread.tss?thread_id=29510
How Can I revolve concurrent access on data in Web Application
More precisely:

I've two user connected in my application that work on same record.
If one of this wait just a minute on change a field in the record and the...]]> Mon, 18 Oct 2004 10:03:09 -0400 Mon, 18 Oct 2004 10:03:09 -0400 Mon, 18 Oct 2004 10:03:09 -0400 Oct 18, 2004 Vincenzo Sorrentino 8