[news.eclipse.birt] Re: Value '0000-00-00' can not be represented as jav

[Jari Fredriksson <jarif@xxxxxxxxxxxxx>]

Mr. Burns wrote:
> Hello,
>
> I use JVM 1.5.0_04, BIRT 2.0.0 and MySQL 4.1.13.
>
> I have a simple MySQL table called R1 with just one column 'MyDate' of type 
> Date.
> There is only one record within this table with following date value: 
> 0000-00-00
>
> In BIRT it is not possible to create a dataset with the query: SELECT * FROM 
> R1
> If  I create ths query inside the querybuilder of BIRT and if I click 
> 'result preview' I get following exception:
>
> Value '0000-00-00' can not be represented as java.sql.Date
>
> With date values like 2004-04-13 it works fine.
> So what if I have the date default value 0000-00-00 in my database?
> Is there any solution or workarround available to solve this problem?
>
> Thanks for any help! 

Java Date begins from 1.1.1970 or something like that.

0.0.0000 is not a valid date after all, maybe NULL would be more suitable.