[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
|
[news.eclipse.birt] Re: Value '0000-00-00' can not be represented as java.sql.Date
|
- From: FreeGroup <a.herz@xxxxxxxxxxxx>
- Date: Mon, 17 Apr 2006 11:41:22 +0200
- Newsgroups: eclipse.birt
- Organization: EclipseCorner
- User-agent: Thunderbird 1.5 (X11/20051201)
Is it really so that MySQL returns a non-null value of 0000-00-00 if the
field is NULL? And isNull() does not tell it is NULL?
A null value should not be tried and assigned to a Java Date.
you can reproduce his problem like:
1. create a not required date column
2. insert some records
3. alter the column to "not null"
4. mySQL fill the column of the existing record with "0000-00-00"!!
stupid behaviour of mySQL.
greetings
andreas