Continuously Deployed Dan Mayer's Dev Blog

I had an issue with java and hibernate returning a null date.

java hibernate java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

This just took a little longer to find the fix on a google search than I thought it should have so I post what I ended up doing to resolve the situation here:

?zeroDateTimeBehavior=convertToNull

you add this to your jdbc connection url and it will convert the 0000-00-00 to the proper type for java to work with.

More info here:

http://dev.mysql.com/doc/mysql/en/cj-upgrading.html#cj-upgrading-3-0-to-3-1

thanks to this thread, which had many other suggestions, but most of them were not helpful, but the one above saved my day.

http://forum.java.sun.com/thread.jspa?threadID=649520&messageID=3824019

you can add this on the end of your hibernate connection file, like so...
jdbc:mysql://{DB_IPADDRESS}:{DB_PORT}/{DB_NAME}?zeroDateTimeBehavior=convertToNull&profileSql=true