Re: (Java) Synchronizing multiple app servers through Oracle

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Thu, 13 Dec 2007 01:07:41 -0800 (PST)
Message-ID: <12479f93-d896-4b3b-9d44-2d959da2f10f@e6g2000prf.googlegroups.com>

On Dec 13, 2:10 am, chrism..._at_gmail.com wrote:
> What is the recommended way for using an Oracle database to
> synchronize multiple app servers? When I speak of synchronizing, I'm
> referring to the Java use of the word, where you can lock a section of
> code so other threads don't access that section at the same time.
>
> I have multiple app servers that each need exclusive access to the
> database for a certain operation. Does Oracle have a semaphore
> utility that is available to apps? I know I could hack it by doing a
> select for update on a dummy table with 1 row, but I was hoping Oracle
> had something more elegant to use.

Hopefully you are aware that this may cause a major bottleneck in your application. This kind of global lock should not be used too frequent and for too long.

Kind regards

robert Received on Thu Dec 13 2007 - 03:07:41 CST