Tag Archives: DB2

Locking a row, portable between databases, with JDBC

A couple of years ago I was with a project designing a system to manage Investor Meetings. An Investor must have a valid Pass in order to join a Meeting. Each Pass has a unique serial number. It was a … Continue reading

Posted in Databases, Java | Tagged , , , , , | 1 Comment

Implementing a simple database semaphore

In this article I will describe a simple technique that enables you to implement an “exclusive lock” in a distributed, even clustered, environment. The technique works with all major databases, and should work with any database that has a reasonable … Continue reading

Posted in Databases, Java | Tagged , , , , , , , , | 11 Comments