Tag Archives: Derby
Unit-testing time/timing dependent components
I’m often faced with developing components that are depending on time or timing, one way or the other. An example can be a query that returns all “active” rows, given current date/time and where the rows have effective and expiry … Continue reading
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
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
Securing J[2]EE applications, part 3
In this third article, the samples are modified to be run on JBoss (4.0.3+) and JavaDB (Derby version 10.2). The first article showed how to setup Glassfish authentication with only a single database table. The second article evovled the simple … Continue reading