Eclipse Community Forums: BIRT » problem to run MySQL Aggregate Functions in birt 2.1.1

Home » Archived » BIRT » problem to run MySQL Aggregate Functions in birt 2.1.1

problem to run MySQL Aggregate Functions in birt 2.1.1 [message #247596]

Thu, 12 July 2007 09:15

Eclipse User

Originally posted by: jem_do.gmail.com

Hi
sorry for my poor english.
I've downloaded Eclipse 3.2 and BIRT 2.1 .

I have a rptdesign which run well in birt 2.0.1 but not run from birt
2.1.1.
This is my query.It run well in birt 2.0.1.
what is the problem??
plz reply me
////////////////////////////////////////////////////////////
select

round(sum(.subject_grade.marks)*100/ sum(.subject_curriculum.full_marks))

from subject,
subject_curriculum,
course_offering,
course_structure,
program_composition,
examination_type,
examination_instance,
examination_roll_no,
examination_instance_item,
course_enrollment,
program_unit,

subject_grade

where .subject_curriculum.subject_id=.subject.subject_id
and
course_offering.subject_curriculum_id=.subject_curriculum.su bject_curriculum_id
and
course_offering.course_structure_item_id=.course_structure.c ourse_structure_item_id
and .program_composition.program_unit_id=.course_structure.progr am_unit_id
and
program_composition.program_composition_item_id=.examination _type.program_composition_item_id
and
examination_type.examination_type_id=.examination_instance.e xamination_type_id
and
examination_instance.examination_instance_id=.examination_ro ll_no.exam_instance_id
and
examination_instance_item.course_offering_item_id=.course_of fering.course_offering_item_id
and
course_enrollment.course_offering_item_id=.course_offering.c ourse_offering_item_id
and .program_unit.program_unit_id=.program_composition.program_u nit_id
and .course_enrollment.student_id=.examination_roll_no.student_i d

and
subject_grade.course_offering_item_id=.examination_instance_ item.course_offering_item_id
and
subject_grade.exam_instance_id=.examination_instance_item.ex amination_instance_id
and .subject_grade.student_id=.examination_roll_no.student_id

//////////////////////////////////////////////////////////// /

Re: problem to run MySQL Aggregate Functions in birt 2.1.1 [message #247737 is a reply to message #247596]

Thu, 12 July 2007 21:31

Eclipse User

Hi

I have try to reproduce your issued in 2.1.1, 2.1.2, 2.1.3 and 2.2.0
build,
My SQL is simple version like yours
select round(sum(orderdetails.priceEach)*100/sum(order_details.Quan tity))
from orderdetails, order_details
where order_details.OrderID != orderdetails.orderNumber

Only 2.1.1 build failed to excute the query and get the error message:
org.eclipse.birt.data.engine.core.DataException: Cannot get the result set
metadata.
SQL statement does not return a ResultSet object.

I think it is the 2.1.1's issue only, so would you please use the 2.1.3 or
2.2.0 release build, they works well. And then we will discuss whether it
should be fixed in 2.1.1 build

BTW my MySQL driver's version is v3.0

Regards~

Re: problem to run MySQL Aggregate Functions in birt 2.1.1 [message #247773 is a reply to message #247737]

Fri, 13 July 2007 04:53

Eclipse User

Hi

We won't fix it in 2.1.1 build, please using the latest 2.1.3 release
build.
Because I have passed your case on that build, if your case still failed
in 2.1.3 please tell me, thanks

Regards

Previous Topic:	About BIRT VIEWER
Next Topic:	Not able to see Report Designer perspective in BIRT 2.2

Goto Forum:

-=] Back to Top [=-

Current Time: Sat May 31 01:34:18 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter