(Haha weird post title. Anyway, I’ll not be talking about some obscure way of venting out my frustration.)

I stumbled upon an FOSS 3D content creation software last week and here I am fantasizing yet again my dream on becoming an animator. I have dreamed of becoming one when Pixar started coming up with those amazing animation movies. Unfortunately, I lack the knack of being artistic yet fortunately, I think I’m not really hopeless enough that I can bring it out through study and practice.

Oh, FOSS, FOSS, FOSS! I am happy that there are free and open source alternatives to your favorite enterprise applications. And since its open source, you really need not wait for the next release to get that functionality that you deemed so important. Well of course if you are a developer, you could be the one to add the functionality. If not, well, if your idea is truly good, I bet some programmer may have already worked on it; just search and build.

I’ve been googling for an easy workaround to a org.hibernate.exception.GenericJDBCException: Value ‘0000-00-00′ can not be represented as java.sql.Timestamp. Changing the zero-dates to null is not actually an option because it might break the (poorly developed) application already using the database. This application I am working would just want to query a few reports from it. So…

Finally, I was able to stumble onto a straightforward solution to the Value ‘0000-00-00′ can not be represented as java.sql.Timestamp exception:

• It is a MySQL specific error.
• You just need to add ?zeroDateTimeBehavior=convertToNull to your connection string (jdbc:mysql://myhost/mydatabase?zeroDateTimeBehavior=convertToNull)

So thank you!