Eclipse Community Forums: BIRT » BIRT calls .class files twice

Home » Archived » BIRT » BIRT calls .class files twice

BIRT calls .class files twice [message #247450]

Wed, 11 July 2007 15: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]

Wed, 11 July 2007 20: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 08: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 09: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 12: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 13: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 13: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 14: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
>

Re: BIRT calls .class files twice [message #247694 is a reply to message #247686]

Thu, 12 July 2007 14:57

Eclipse User

Originally posted by: hmehta.familydollar.com

Hello Jason,

I never use wiki. Can you please provide a link?

Thank you.

Hardik

Re: BIRT calls .class files twice [message #247702 is a reply to message #247694]

Thu, 12 July 2007 15:00

Eclipse User

Originally posted by: jasonweathersby.alltel.net

http://wiki.eclipse.org/Servlet_Example

Hardik wrote:
> Hello Jason,
>
> I never use wiki. Can you please provide a link?
>
> Thank you.
>
> Hardik
>

Previous Topic:	strange console output after setting JNDI
Next Topic:	Need some advice on report design - Please help

Goto Forum:

-=] Back to Top [=-

Current Time: Fri May 09 21:12:50 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter