Description Sriraman Srinivasan 2010-09-09 06:36:01 EDT

Build Identifier: Birt  2.2.1

If we try to create a report with Timestamp/Date parameter in the where clause, we are not able to generate a report. We get a oracle error stating invalid month.

Reproducible: Always

Steps to Reproduce:
1. create a report with parameter of oracle Timestamp type. In birt report we configure this as a DateTime parameter. Below is the select statement for the same.
select *
from DASH1.SRIRAMAN_TEST
where DASH1.SRIRAMAN_TEST.DATETIME = ?

The parameter DASH1.SRIRAMAN_TEST.DATETIME is of Oracle TimeStamp type.

2. Try generating the report i.e. preview.
3.You will get a error message stating as below:
The following items have errors: 


ReportDesign (id = 1): 
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01843: not a valid month

4. A similar error when the parameter is of Oracle Date type and we use it as 
DateTime parameter in birt. Below is the error message for the same

The following items have errors: 


ReportDesign (id = 1): 
+ Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01861: literal does not match format string