Saturday, March 17, 2012

Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

Hey!

I have a Timestamp Field with a Null Value. But the JDBC say the following error message:

Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp

Seems that MySQL convert a null timestamp into '0000-00-00 00:00:00. Anybody prefered to set this flag zeroDateTimeBehavior=convertToNull

But I found no way to set it in Cloud SQL. Is it possible to set this flag?

Regards, 

Markus

No comments:

Post a Comment