birt upgrade blankdate problem [message #484263] |
Fri, 04 September 2009 22:59 |
Eclipse User |
|
|
|
Originally posted by: verljj.adigitalsys.com
Recently upgraded from Birt 2.2.1.1 to version 2.5
Everything worked fine before the upgrade, but now after the upgrade,
anytime my dataset selects a date column that contains blank (not null)
values I get the following error:
Cannot get timestamp value in the result set.
SQLerror #1: DATE/TIME value not in standard format.
I realize I could change the datatype in the database to use a null value
instead of a blank value, but then this will break allot of legacy code
elsewhere.
Is there a way to tell Birt to automatically change the blank date to a
Null?
Thanks.
Verl
|
|
|
Re: birt upgrade blankdate problem [message #484657 is a reply to message #484263] |
Tue, 08 September 2009 16:17 |
|
Verl,
BIRT does have mapping capabilities but in this case I do not think it
will work because the error is coming from the JDBC ODA. Any chance you
could log a bug for this?
Jason
verl wrote:
> Recently upgraded from Birt 2.2.1.1 to version 2.5
>
> Everything worked fine before the upgrade, but now after the upgrade,
> anytime my dataset selects a date column that contains blank (not null)
> values I get the following error:
>
> Cannot get timestamp value in the result set.
> SQLerror #1: DATE/TIME value not in standard format.
>
> I realize I could change the datatype in the database to use a null
> value instead of a blank value, but then this will break allot of legacy
> code elsewhere.
>
> Is there a way to tell Birt to automatically change the blank date to a
> Null?
>
> Thanks.
>
> Verl
>
|
|
|
Powered by
FUDForum. Page generated in 0.06012 seconds