Monthly Archives: February 2010

Unique constraint violated

Recently I spent a fair bit of time trying to figure out why I kept encountering the unique constraint violation during unit testing.

The column in question wasn’t a primary key. Neither was there a table constraint for it’s uniqueness.

I was puzzled. Until finally when I took a look at it’s Hibernate mapping. That column had the tag, natural-id.

That explains everything.

— Post From My iPhone


Character escaping with Hibernate ORM

Last week, a friend told me his developer shared that explicit character escaping is needed with Hibernate.

I doubted. Unless of course he was constructing his own SQL, which he wasn’t.

To prove, I did a simple insert into a VCHAR column of the Oracle table and found that the so called special characters of single quote and ampersand got persisted as it is. And no escaping was needed on my part.

— Post From My iPhone

Apple iPhoto – Facial Recognition

It’s interesting to read that iPhoto actually allows tagging of face in photos which can then be searched via spotlight.

Not sure if you’ve to tag all photos or just one and have spotlight find all photos for you.

Gonna try it out when I have the time!

— Post From My iPhone

What’s the future of MySQL?

Now that the Sun belongs to Oracle, what would happen to MySQL? Does it make economic sense for Oracle to keep investing in MySQL? What would happen to the customers, developers and community behind MySQL?

Although it makes good money sense to acquire Sun and therefore MySQL, is such a move really good for the consumers? Afterall, we have an option lesser now. Well not that we could really compare both DBMS on equal grounds, but at least there is an option for free and reliable DBMS when our needs aren’t enterprise level or mission critical.

Also, for those who had certified in MySQL, would their investments in both time and money be wasted?

There are a lot of open source applications out there running on MySQL database, whatever would happen to them?

Would a community version of MySQL be still available with the same level of developments and committments?

Would creativity be limited since there are lesser viable vendors now? The options are now either Oracle, IBM or Microsoft. Would this be really good for SMEs who can’t afford to pay for such enterprise solutions?

On the other hand, from a monetary point of view, open source is indeed a viable means of making good money. Afterall, a successful product may get acquired for good money!

Only time will tell of what would ever become of MySQL. Until then, I could only hope that my applications still runs free.

— Post From My iPhone