Sat, 30 May 2009
10:20 PM - Annoying MySQL issue with jdbc
Ever get this? Cannot convert value '0000-00-00 00:00:00' from column to TIMESTAMP.
The problem is that the MySQL jdbc driver doesn't map it to null. There are flags to the connection that are supposed to do this for you, but I've had no luck getting them to work. I have two timestamp fields on the User table for this site. I wrote a MySQL to java data mapper years ago, but now that I'm converting to Cayenne, I can't use that anymore. Time to fix the database :)