cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: mysql date
Date Thu, 07 Dec 2006 08:50:08 GMT

On Dec 5, 2006, at 12:36 PM, Peter Schröder wrote:

> hi there,
> first of all the bug-tracking link on page http:// 
> is broken :-( but  
> i found it through google.

Thanks for pointing it out. I fixed it on the site - it will be  
published within an hour.

> we have a lot of old data stored in our mysql-database. there are  
> lots of date-fields with date of '0000-00-00 00:00:00' (which  
> should in deed be 'null') which cause cayenne to fail on fetching  
> data-objects, cause it cant convert the date: Value '0000-00-00'  
> can not be represented as java.sql.Timestamp.
> do i have to update all these fields to null, so that cayenne can  
> work properly?

What is the exception? I would assume this is thrown at the driver  
level, not Cayenne, but if you can provide more details, maybe there  
is a way for us to create a workaround.


View raw message