| Integer parameter not working in 2.2.1.1? [message #261086] |
Fri, 09 November 2007 14:28 |
Eclipse User |
|
|
|
Have a number of reports written in 2.2 with queries bound to a report
paremeter that was defined as an integer. In all of the data, the number is
an integer - a sequence ID on a table. In 2.2.1.1 the dataset fails to load.
The error that appears is:
detail : org.eclipse.birt.report.data.adapter.api.AdapterException:
Cannot get the result set metadata.
SQL statement does not return a ResultSet object.
SQL error #1: ORA-01722: invalid number
This is pretty counter-intuitive since the parameter is being passed to an
Oracle number column, but fails when the parameter type is set to 'Integer'
and works when it is set to 'String.'
Is there something I should look for elsewhere? In the parameter binding on
the data set the type is set to "any". I tried changing it to 'Integer' to
match the report parameter type of 'Integer', but it still didn't work. It
continues to work when I change the report parameter type to 'String' and
leave it at 'Any.'
Thoughts? Am I missing something somewhere else? Again, I can open the same
report up in 2.2 side-by-side with 2.2.1.1, and it still works in 2.2.
|
|
|
Powered by
FUDForum. Page generated in 0.05902 seconds
Home