Search My Ramblings

Showing posts with label Oracle LOCK semaphore integration multithreaded singleton. Show all posts
Showing posts with label Oracle LOCK semaphore integration multithreaded singleton. Show all posts

Thursday, September 10, 2009

Using DBMS_LOCK package to implement singleton pattern

One thing that is inevitable as you start replacing batch-oriented integration strategies with more real-time, transactional strategies like BPEL and ESB, especially in a clustered environment, is that you'll run into APIs and database procedures that worked fine in a batch mode, but in a multi-threaded real time integration start breaking.