Re: mysql date

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Dec 07 2006 - 03:50:08 EST

  • Next message: Peter Schröder: "AW: mysql date"

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

    > hi there,
    >
    > first of all the bug-tracking link on page http://
    > incubator.apache.org/cayenne/how-can-i-help.html 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.

    Andrus



    This archive was generated by hypermail 2.0.0 : Thu Dec 07 2006 - 03:50:46 EST