[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
FreeGroup wrote: 
Hi,

I have had the same problem with mySQL in another project.
The 0000-00-00 is a mySQL "feature" and you have the problem
in the JDBC driver. You must fix the DB values.


greetings

Andreas


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.