Re: (Java) Synchronizing multiple app servers through Oracle

On Dec 13, 4:07 am, Robert Klemme <shortcut...@xxxxxxxxxxxxxx> wrote:
On Dec 13, 2:10 am, chrism...@xxxxxxxxx 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

Typically the lock will last less than one second.
.

Relevant Pages

  • Re: (Java) Synchronizing multiple app servers through Oracle
    ... synchronize multiple app servers? ... referring to the Java use of the word, where you can lock a section of ... select for update on a dummy table with 1 row, but I was hoping Oracle ... Oracle locks rows by default (it doesn't matter if it's java, C#, VB, ...
    (comp.databases.oracle.server)
  • Re: (Java) Synchronizing multiple app servers through Oracle
    ... synchronize multiple app servers? ... select for update on a dummy table with 1 row, but I was hoping Oracle ... This kind of global lock should not be used too frequent ... Kind regards ...
    (comp.databases.oracle.server)
  • Re: Lock-free databases
    ... > lock, latch, enqueue, or other name is a lock for the purpose of this ... Database concurrency control. ... be it Oracle or SQL Server ...
    (comp.databases.theory)
  • Re: Informix beats Oracle
    ... What's the difference between that and this new feature? ... similar to the Oracle implementation, and was not available in other products. ... Using this, you won't block when trying to read a row that has a lock. ... I'm "tired" of explaining the locking issues to developers that were trained only in Oracle... ...
    (comp.databases.informix)
  • Re: Deadlock - advice needed
    ... Lock table order_release_bp in share mode; ... Resource Name process session holds waits process session holds waits ... After reading about the Oracle locking, my guess is the the stored ... "Unindexed foreign keys cause DML on the primary key to get a share row ...
    (comp.databases.oracle.server)
Loading