| Patch 2.1.1 SQL division error [message #200212] |
Fri, 10 November 2006 07:31  |
Eclipse User |
|
|
|
Originally posted by: jgngo.yahoo.com
After upgrading BIRT to 2.1.1 from 2.1, the reports that contain a
division operator in the SQL statement runs with errors (i.e. SELECT
month, sales / 12 FROM table1). This is a bug in 2.1.1 which was
corrected in 2.2. Unfortunately, 2.2 is still a milestone release and
most reports do not work anymore.
As discussed in a newsgroup thread, the solution (until 2.2 is
released), is to download rcp-report-designer-2.2.0 and copy the
oda-jdbc.jar found in:
birt-rcp-report-designer-2_2_0\plugins\org.eclipse.birt.repo rt.data.oda.jdbc_2.2.0.v20061009-0630
and replace the oda-jdbc.jar found at:
eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.1.1. v20060922-1058
The solution made the reports work again. However, combo box report
parameters now have an error. Is there another jar that I need to replace?
|
|
|
| Re: Patch 2.1.1 SQL division error [message #200391 is a reply to message #200212] |
Sat, 11 November 2006 07:53  |
| Eclipse User |
|
|
|
Originally posted by: jgngo.yahoo.com
Found the solution to this. I got the oda-jdbc.jar from the latest
nightly build of 2.1.2 and replaced the existing one in 2.1.1. All my
reports are now working. I hope the BIRT team officially releases 2.1.2
already. SQL statements that have division expressions within are fairly
common.
Jason Ngo wrote:
> After upgrading BIRT to 2.1.1 from 2.1, the reports that contain a
> division operator in the SQL statement runs with errors (i.e. SELECT
> month, sales / 12 FROM table1). This is a bug in 2.1.1 which was
> corrected in 2.2. Unfortunately, 2.2 is still a milestone release and
> most reports do not work anymore.
>
> As discussed in a newsgroup thread, the solution (until 2.2 is
> released), is to download rcp-report-designer-2.2.0 and copy the
> oda-jdbc.jar found in:
> birt-rcp-report-designer-2_2_0\plugins\org.eclipse.birt.repo rt.data.oda.jdbc_2.2.0.v20061009-0630
>
>
> and replace the oda-jdbc.jar found at:
> eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_2.1.1. v20060922-1058
>
> The solution made the reports work again. However, combo box report
> parameters now have an error. Is there another jar that I need to replace?
|
|
|
Powered by
FUDForum. Page generated in 0.03343 seconds
Home