| BIRT calls .class files twice [message #247450] |
Wed, 11 July 2007 19:39  |
Eclipse User |
|
|
|
Originally posted by: hmehta.familydollar.com
Hi,
I am using java class file to send queries from BIRT to java and after
making some calculation in java I send result back to BIRT using vector.
Problem is, BIRT calls java class file twice at the time of execution. It
shows correct result but because of calling class file twice execution
time becomes double. It take almost 2 min to run the report.
Any Idea?
Thanks in advance.
Hardik
|
|
|
| Re: BIRT calls .class files twice [message #247492 is a reply to message #247450] |
Thu, 12 July 2007 00:27  |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Hardik,
If you are doing this with a scripted data set, every time you bind the
data set to a table it will run. So if you have it in two tables it
will run twice. This should be fixed when 2.1.1 comes out.
Jason
Hardik wrote:
> Hi,
>
> I am using java class file to send queries from BIRT to java and after
> making some calculation in java I send result back to BIRT using vector.
> Problem is, BIRT calls java class file twice at the time of execution.
> It shows correct result but because of calling class file twice
> execution time becomes double. It take almost 2 min to run the report.
>
> Any Idea?
>
> Thanks in advance.
>
> Hardik
>
|
|
|
| Re: BIRT calls .class files twice [message #247586 is a reply to message #247492] |
Thu, 12 July 2007 12:14 |
| Eclipse User |
|
|
|
Originally posted by: spenser.emery.gmail.com
Hi Jason,
Did you mean 2.2.1 when you said "This should be fixed when 2.1.1 comes
out"?
Also, is this the same issue as the same SQL statement (or in my case, call
to executeQuery() on a custom ODA plugin) being called multiple times on the
same report?
I remember reading something just over a month ago about problems with
executing the samy query multiple times and a "not very good" workaround
being to tell BIRT to always cache results. Has this issue been fixed and if
so, in which version of BIRT?
Thank you for your time,
Spenser
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:f73sen$eb0$1@build.eclipse.org...
> Hardik,
>
> If you are doing this with a scripted data set, every time you bind the
> data set to a table it will run. So if you have it in two tables it will
> run twice. This should be fixed when 2.1.1 comes out.
>
> Jason
>
> Hardik wrote:
>> Hi,
>>
>> I am using java class file to send queries from BIRT to java and after
>> making some calculation in java I send result back to BIRT using vector.
>> Problem is, BIRT calls java class file twice at the time of execution. It
>> shows correct result but because of calling class file twice execution
>> time becomes double. It take almost 2 min to run the report.
>>
>> Any Idea?
>>
>> Thanks in advance.
>>
>> Hardik
>>
|
|
|
| Re: BIRT calls .class files twice [message #247601 is a reply to message #247586] |
Thu, 12 July 2007 13:23 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
I meant 2.2.1 and this is probably that same issue.
Jason
Spenser Emery wrote:
> Hi Jason,
>
> Did you mean 2.2.1 when you said "This should be fixed when 2.1.1 comes
> out"?
>
> Also, is this the same issue as the same SQL statement (or in my case, call
> to executeQuery() on a custom ODA plugin) being called multiple times on the
> same report?
>
> I remember reading something just over a month ago about problems with
> executing the samy query multiple times and a "not very good" workaround
> being to tell BIRT to always cache results. Has this issue been fixed and if
> so, in which version of BIRT?
>
> Thank you for your time,
>
> Spenser
> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
> news:f73sen$eb0$1@build.eclipse.org...
>> Hardik,
>>
>> If you are doing this with a scripted data set, every time you bind the
>> data set to a table it will run. So if you have it in two tables it will
>> run twice. This should be fixed when 2.1.1 comes out.
>>
>> Jason
>>
>> Hardik wrote:
>>> Hi,
>>>
>>> I am using java class file to send queries from BIRT to java and after
>>> making some calculation in java I send result back to BIRT using vector.
>>> Problem is, BIRT calls java class file twice at the time of execution. It
>>> shows correct result but because of calling class file twice execution
>>> time becomes double. It take almost 2 min to run the report.
>>>
>>> Any Idea?
>>>
>>> Thanks in advance.
>>>
>>> Hardik
>>>
>
>
|
|
|
| Re: BIRT calls .class files twice [message #247635 is a reply to message #247492] |
Thu, 12 July 2007 16:04 |
| Eclipse User |
|
|
|
Originally posted by: hmehta.familydollar.com
Hi,
Thanks for your reply.
You are right I used scripted data source. I have few more question for
same issue.
I designed a report which displays only Pie chart (it doesnt include any
other display than PIE chart, no tables no extra chart nothing), that
report also calls class files twice. I have designed almost 20 reports in
recent times all are displays charts. only one or two displays tables. but
I am getting same problem with all the reports. Is there any way to over
come in BIRT 2.1?
Thank you.
Hardik
|
|
|
| Re: BIRT calls .class files twice [message #247663 is a reply to message #247635] |
Thu, 12 July 2007 17:39 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Hardik,
i apologize these are two different issues. in BIRT 2.1 datasets are
not cached, meaning they are called every time you use them. The issue
you are referring to is when using just one chart the dataset gets
called twice. That bug is 151427 and was fixed in the 2.2 build. In
2.1 this bug only happens if you use a runandrender task, if you are
using the WebViewer this error should not occur.
Jason
Hardik wrote:
> Hi,
>
> Thanks for your reply.
>
> You are right I used scripted data source. I have few more question for
> same issue.
>
> I designed a report which displays only Pie chart (it doesnt include any
> other display than PIE chart, no tables no extra chart nothing), that
> report also calls class files twice. I have designed almost 20 reports
> in recent times all are displays charts. only one or two displays
> tables. but I am getting same problem with all the reports. Is there any
> way to over come in BIRT 2.1?
>
> Thank you.
>
> Hardik
>
|
|
|
| Re: BIRT calls .class files twice [message #247673 is a reply to message #247663] |
Thu, 12 July 2007 17:50 |
| Eclipse User |
|
|
|
Originally posted by: hmehta.familydollar.com
Hi,
Thanks Jason.
I am used run_report to execute reports as HTML in web browser. As you
said this should have happened because I used run and rendor.
Now I have to think something different.
Thank you.
Hardik
|
|
|
| Re: BIRT calls .class files twice [message #247686 is a reply to message #247673] |
Thu, 12 July 2007 18:56 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Hardik,
You could try using the example servlet from the wiki to do a run and
then a separate render.
Jason
Hardik wrote:
> Hi,
>
> Thanks Jason.
>
> I am used run_report to execute reports as HTML in web browser. As you
> said this should have happened because I used run and rendor.
>
> Now I have to think something different.
>
> Thank you.
>
> Hardik
>
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03232 seconds
] 
Search
Help
Register
Login
Home
