Re: (Java) Synchronizing multiple app servers through Oracle

On Dec 13, 11:13 pm, chrism...@xxxxxxxxx wrote:
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.

I'd say that's pretty long. How often will you - pardon, your
application - acquire the lock and what's the general load pattern of
the application?

Kind regards

robert
.

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: (Java) Synchronizing multiple app servers through Oracle
    ... synchronize multiple app servers? ... I have multiple app servers that each need exclusive access to the ... select for update on a dummy table with 1 row, but I was hoping Oracle ... 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)
Loading