Tag Archives: Database
YN
Yeah, I know, this isn’t rocket science. But it is rather nice 🙂 So, I’m working on this JEE project, backed by an Oracle database. Some of my work involves refactoring CMP 2.1 entities into JPA entities. Here I’m faced … Continue reading
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
The “changing the database” experience
I have been involved in Enterprise JAVA projects since 1998. Almost all projects have had an RDBMS “behind” it, mostly Oracle and DB2. All the projects have been some custom defined application often based on existing infrastructure, and the database … Continue reading
Why I love PostgreSQL
Now, I’ve written some ranting about why I hate MySQL, now it is time to write about another Open Source RDBMS, PostgreSQL. In this blog I am going through why I think PostgreSQL is a great database – comparable with … Continue reading
Why I Hate MySQL
MySQL databases have been offered by most web hosting companies for a couple of years. This is the main reason I still have to deal with this product, which claims to be an “enterprise ready” relational database. Unfortunately these companies … Continue reading
View Jesper Udby's profile