Home » Archived » BIRT » BIRT Chart with scripted data source invokes the method twice
| BIRT Chart with scripted data source invokes the method twice [message #255894] |
Thu, 20 September 2007 23:44  |
Eclipse User |
|
|
|
Originally posted by: vencat.b.gmail.com
Hi david/jason,
I have a report with chart designed using scripted data source (POJO). For
some strange reason, its executing the pojo method twice and this results to
querying database twice.
I'm using BIRT 2.1.3 and this is line chart.
Please let me know.
Thanks
|
|
| | | | | | | |
| Re: BIRT Chart with scripted data source invokes the method twice [message #256183 is a reply to message #256166] |
Tue, 25 September 2007 19:11  |
| Eclipse User |
|
|
|
Originally posted by: vencat.b.gmail.com
Jason,
Can you elaborate further on this approach. Any workaround is good for me.
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:fdbpgf$9eb$1@build.eclipse.org...
> Venc,
>
> Can you not use a hash as a work around?
>
> Jason
>
> venc wrote:
>> Please do and many thanks. We have multiple charts in a dashboard and you
>> can imagine how bad this would be because of each chart query being
>> executed twice.
>>
>>
>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>> news:fdb87m$761$1@build.eclipse.org...
>>> Venc,
>>>
>>> I will check into it, but I do not believe there are any plans to do
>>> that currently.
>>>
>>> Jason
>>>
>>> venc wrote:
>>>> Thanks jason for looking into the details of this. Is there any chance
>>>> this bug fix be back-patched to 2.1.3 release.
>>>>
>>>> Thank you.
>>>>
>>>>
>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>> news:fd8mvj$rfr$1@build.eclipse.org...
>>>>> Venc,
>>>>>
>>>>> Look at this entry.
>>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=151427
>>>>>
>>>>> Jason
>>>>>
>>>>> venc wrote:
>>>>>> Hi jason,
>>>>>> Thanks for quick response. Is there bugzilla entry for this? Also
>>>>>> will there be another patch release to 2.1.3. This seems a critical
>>>>>> and fundamental performance issue. I'm not sure if this is with other
>>>>>> data sources as well.
>>>>>>
>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>> news:fd0qrh$7lu$1@build.eclipse.org...
>>>>>>> Venc,
>>>>>>>
>>>>>>> I believe this is a known issue. Should be corrected soon. One
>>>>>>> work around might be to load a hash with your result sets and then
>>>>>>> check the hash the second time the script runs.
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> venc wrote:
>>>>>>>> Hi david/jason,
>>>>>>>> I have a report with chart designed using scripted data source
>>>>>>>> (POJO). For some strange reason, its executing the pojo method
>>>>>>>> twice and this results to querying database twice.
>>>>>>>>
>>>>>>>> I'm using BIRT 2.1.3 and this is line chart.
>>>>>>>>
>>>>>>>> Please let me know.
>>>>>>>>
>>>>>>>> Thanks
>>
|
|
|
| Re: BIRT Chart with scripted data source invokes the method twice [message #256272 is a reply to message #256183] |
Wed, 26 September 2007 10:09 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Venc,
I am not certain how your SDS is working, but if you are calling an
external POJO to get the rows you can set a global variable in BIRT
script the first time you run the SDS. At the same time in Script
create a Java HashMap to hold your rows. The second time through read
the HashMap for rowdata instead of your external system. This will
still be a performance hit, but should not be as bad.
Jason
venc wrote:
> Jason,
> Can you elaborate further on this approach. Any workaround is good for me.
>
>
> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
> news:fdbpgf$9eb$1@build.eclipse.org...
>> Venc,
>>
>> Can you not use a hash as a work around?
>>
>> Jason
>>
>> venc wrote:
>>> Please do and many thanks. We have multiple charts in a dashboard and you
>>> can imagine how bad this would be because of each chart query being
>>> executed twice.
>>>
>>>
>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>> news:fdb87m$761$1@build.eclipse.org...
>>>> Venc,
>>>>
>>>> I will check into it, but I do not believe there are any plans to do
>>>> that currently.
>>>>
>>>> Jason
>>>>
>>>> venc wrote:
>>>>> Thanks jason for looking into the details of this. Is there any chance
>>>>> this bug fix be back-patched to 2.1.3 release.
>>>>>
>>>>> Thank you.
>>>>>
>>>>>
>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>> news:fd8mvj$rfr$1@build.eclipse.org...
>>>>>> Venc,
>>>>>>
>>>>>> Look at this entry.
>>>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=151427
>>>>>>
>>>>>> Jason
>>>>>>
>>>>>> venc wrote:
>>>>>>> Hi jason,
>>>>>>> Thanks for quick response. Is there bugzilla entry for this? Also
>>>>>>> will there be another patch release to 2.1.3. This seems a critical
>>>>>>> and fundamental performance issue. I'm not sure if this is with other
>>>>>>> data sources as well.
>>>>>>>
>>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>>> news:fd0qrh$7lu$1@build.eclipse.org...
>>>>>>>> Venc,
>>>>>>>>
>>>>>>>> I believe this is a known issue. Should be corrected soon. One
>>>>>>>> work around might be to load a hash with your result sets and then
>>>>>>>> check the hash the second time the script runs.
>>>>>>>>
>>>>>>>> Jason
>>>>>>>>
>>>>>>>> venc wrote:
>>>>>>>>> Hi david/jason,
>>>>>>>>> I have a report with chart designed using scripted data source
>>>>>>>>> (POJO). For some strange reason, its executing the pojo method
>>>>>>>>> twice and this results to querying database twice.
>>>>>>>>>
>>>>>>>>> I'm using BIRT 2.1.3 and this is line chart.
>>>>>>>>>
>>>>>>>>> Please let me know.
>>>>>>>>>
>>>>>>>>> Thanks
>
|
|
|
| Re: BIRT Chart with scripted data source invokes the method twice [message #256517 is a reply to message #256272] |
Fri, 28 September 2007 10:06 |
| Eclipse User |
|
|
|
Originally posted by: vencat.b.gmail.com
Thanks jason. I have to think about how this would work. I tried few things
using parameter to ignore either the first or second call but did not work
for me. I wish this was fixed. I chose BIRT over crystal and i hope this
works out well for me. Please check with PMC and let me know if this could
be fixed for 2.1.3.
Even difference in rendering times between using /run and /frameset is
something i could not understand. /frameset downloads about 15-20 JS files
and i did not experience these pagination issues when using crystal JRC.
"Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
news:fddp1g$gi6$1@build.eclipse.org...
> Venc,
>
> I am not certain how your SDS is working, but if you are calling an
> external POJO to get the rows you can set a global variable in BIRT script
> the first time you run the SDS. At the same time in Script create a Java
> HashMap to hold your rows. The second time through read the HashMap for
> rowdata instead of your external system. This will still be a performance
> hit, but should not be as bad.
>
> Jason
>
> venc wrote:
>> Jason,
>> Can you elaborate further on this approach. Any workaround is good for
>> me.
>>
>>
>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>> news:fdbpgf$9eb$1@build.eclipse.org...
>>> Venc,
>>>
>>> Can you not use a hash as a work around?
>>>
>>> Jason
>>>
>>> venc wrote:
>>>> Please do and many thanks. We have multiple charts in a dashboard and
>>>> you can imagine how bad this would be because of each chart query being
>>>> executed twice.
>>>>
>>>>
>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>> news:fdb87m$761$1@build.eclipse.org...
>>>>> Venc,
>>>>>
>>>>> I will check into it, but I do not believe there are any plans to do
>>>>> that currently.
>>>>>
>>>>> Jason
>>>>>
>>>>> venc wrote:
>>>>>> Thanks jason for looking into the details of this. Is there any
>>>>>> chance this bug fix be back-patched to 2.1.3 release.
>>>>>>
>>>>>> Thank you.
>>>>>>
>>>>>>
>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>> news:fd8mvj$rfr$1@build.eclipse.org...
>>>>>>> Venc,
>>>>>>>
>>>>>>> Look at this entry.
>>>>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=151427
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> venc wrote:
>>>>>>>> Hi jason,
>>>>>>>> Thanks for quick response. Is there bugzilla entry for this?
>>>>>>>> Also will there be another patch release to 2.1.3. This seems a
>>>>>>>> critical and fundamental performance issue. I'm not sure if this is
>>>>>>>> with other data sources as well.
>>>>>>>>
>>>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>>>> news:fd0qrh$7lu$1@build.eclipse.org...
>>>>>>>>> Venc,
>>>>>>>>>
>>>>>>>>> I believe this is a known issue. Should be corrected soon. One
>>>>>>>>> work around might be to load a hash with your result sets and then
>>>>>>>>> check the hash the second time the script runs.
>>>>>>>>>
>>>>>>>>> Jason
>>>>>>>>>
>>>>>>>>> venc wrote:
>>>>>>>>>> Hi david/jason,
>>>>>>>>>> I have a report with chart designed using scripted data source
>>>>>>>>>> (POJO). For some strange reason, its executing the pojo method
>>>>>>>>>> twice and this results to querying database twice.
>>>>>>>>>>
>>>>>>>>>> I'm using BIRT 2.1.3 and this is line chart.
>>>>>>>>>>
>>>>>>>>>> Please let me know.
>>>>>>>>>>
>>>>>>>>>> Thanks
>>
|
|
|
| Re: BIRT Chart with scripted data source invokes the method twice [message #256841 is a reply to message #256517] |
Tue, 02 October 2007 20:49 |
| Eclipse User |
|
|
|
Originally posted by: vencat.b.gmail.com
hi jason,
I noticed that this problem exists only using /run and not /frameset.
/run POJO method gets invoked twice
/frameset POJO method invoked only once.
I'm thinking write a servlet which simulates /frameset to display on
dashboard with no BIRT Toolbar. Would that work and how should i? I think
RunAndRender task has this issue. Thanks
"venc" <vencat.b@gmail.com> wrote in message
news:fdj1ng$v9t$1@build.eclipse.org...
> Thanks jason. I have to think about how this would work. I tried few
> things using parameter to ignore either the first or second call but did
> not work for me. I wish this was fixed. I chose BIRT over crystal and i
> hope this works out well for me. Please check with PMC and let me know if
> this could be fixed for 2.1.3.
>
> Even difference in rendering times between using /run and /frameset is
> something i could not understand. /frameset downloads about 15-20 JS files
> and i did not experience these pagination issues when using crystal JRC.
>
>
>
> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
> news:fddp1g$gi6$1@build.eclipse.org...
>> Venc,
>>
>> I am not certain how your SDS is working, but if you are calling an
>> external POJO to get the rows you can set a global variable in BIRT
>> script the first time you run the SDS. At the same time in Script create
>> a Java HashMap to hold your rows. The second time through read the
>> HashMap for rowdata instead of your external system. This will still be
>> a performance hit, but should not be as bad.
>>
>> Jason
>>
>> venc wrote:
>>> Jason,
>>> Can you elaborate further on this approach. Any workaround is good for
>>> me.
>>>
>>>
>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>> news:fdbpgf$9eb$1@build.eclipse.org...
>>>> Venc,
>>>>
>>>> Can you not use a hash as a work around?
>>>>
>>>> Jason
>>>>
>>>> venc wrote:
>>>>> Please do and many thanks. We have multiple charts in a dashboard and
>>>>> you can imagine how bad this would be because of each chart query
>>>>> being executed twice.
>>>>>
>>>>>
>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>> news:fdb87m$761$1@build.eclipse.org...
>>>>>> Venc,
>>>>>>
>>>>>> I will check into it, but I do not believe there are any plans to do
>>>>>> that currently.
>>>>>>
>>>>>> Jason
>>>>>>
>>>>>> venc wrote:
>>>>>>> Thanks jason for looking into the details of this. Is there any
>>>>>>> chance this bug fix be back-patched to 2.1.3 release.
>>>>>>>
>>>>>>> Thank you.
>>>>>>>
>>>>>>>
>>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>>> news:fd8mvj$rfr$1@build.eclipse.org...
>>>>>>>> Venc,
>>>>>>>>
>>>>>>>> Look at this entry.
>>>>>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=151427
>>>>>>>>
>>>>>>>> Jason
>>>>>>>>
>>>>>>>> venc wrote:
>>>>>>>>> Hi jason,
>>>>>>>>> Thanks for quick response. Is there bugzilla entry for this?
>>>>>>>>> Also will there be another patch release to 2.1.3. This seems a
>>>>>>>>> critical and fundamental performance issue. I'm not sure if this
>>>>>>>>> is with other data sources as well.
>>>>>>>>>
>>>>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>>>>> news:fd0qrh$7lu$1@build.eclipse.org...
>>>>>>>>>> Venc,
>>>>>>>>>>
>>>>>>>>>> I believe this is a known issue. Should be corrected soon. One
>>>>>>>>>> work around might be to load a hash with your result sets and
>>>>>>>>>> then check the hash the second time the script runs.
>>>>>>>>>>
>>>>>>>>>> Jason
>>>>>>>>>>
>>>>>>>>>> venc wrote:
>>>>>>>>>>> Hi david/jason,
>>>>>>>>>>> I have a report with chart designed using scripted data source
>>>>>>>>>>> (POJO). For some strange reason, its executing the pojo method
>>>>>>>>>>> twice and this results to querying database twice.
>>>>>>>>>>>
>>>>>>>>>>> I'm using BIRT 2.1.3 and this is line chart.
>>>>>>>>>>>
>>>>>>>>>>> Please let me know.
>>>>>>>>>>>
>>>>>>>>>>> Thanks
>>>
>
>
|
|
|
| Re: BIRT Chart with scripted data source invokes the method twice [message #256925 is a reply to message #256841] |
Wed, 03 October 2007 12:22 |
| Eclipse User |
|
|
|
Originally posted by: jasonweathersby.alltel.net
Venc,
That may work. Just make sure to do a run task and then a render task.
Do not use the RunAndRender task.
Jason
venc wrote:
> hi jason,
> I noticed that this problem exists only using /run and not /frameset.
>
> /run POJO method gets invoked twice
> /frameset POJO method invoked only once.
>
> I'm thinking write a servlet which simulates /frameset to display on
> dashboard with no BIRT Toolbar. Would that work and how should i? I think
> RunAndRender task has this issue. Thanks
>
> "venc" <vencat.b@gmail.com> wrote in message
> news:fdj1ng$v9t$1@build.eclipse.org...
>> Thanks jason. I have to think about how this would work. I tried few
>> things using parameter to ignore either the first or second call but did
>> not work for me. I wish this was fixed. I chose BIRT over crystal and i
>> hope this works out well for me. Please check with PMC and let me know if
>> this could be fixed for 2.1.3.
>>
>> Even difference in rendering times between using /run and /frameset is
>> something i could not understand. /frameset downloads about 15-20 JS files
>> and i did not experience these pagination issues when using crystal JRC.
>>
>>
>>
>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>> news:fddp1g$gi6$1@build.eclipse.org...
>>> Venc,
>>>
>>> I am not certain how your SDS is working, but if you are calling an
>>> external POJO to get the rows you can set a global variable in BIRT
>>> script the first time you run the SDS. At the same time in Script create
>>> a Java HashMap to hold your rows. The second time through read the
>>> HashMap for rowdata instead of your external system. This will still be
>>> a performance hit, but should not be as bad.
>>>
>>> Jason
>>>
>>> venc wrote:
>>>> Jason,
>>>> Can you elaborate further on this approach. Any workaround is good for
>>>> me.
>>>>
>>>>
>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>> news:fdbpgf$9eb$1@build.eclipse.org...
>>>>> Venc,
>>>>>
>>>>> Can you not use a hash as a work around?
>>>>>
>>>>> Jason
>>>>>
>>>>> venc wrote:
>>>>>> Please do and many thanks. We have multiple charts in a dashboard and
>>>>>> you can imagine how bad this would be because of each chart query
>>>>>> being executed twice.
>>>>>>
>>>>>>
>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>> news:fdb87m$761$1@build.eclipse.org...
>>>>>>> Venc,
>>>>>>>
>>>>>>> I will check into it, but I do not believe there are any plans to do
>>>>>>> that currently.
>>>>>>>
>>>>>>> Jason
>>>>>>>
>>>>>>> venc wrote:
>>>>>>>> Thanks jason for looking into the details of this. Is there any
>>>>>>>> chance this bug fix be back-patched to 2.1.3 release.
>>>>>>>>
>>>>>>>> Thank you.
>>>>>>>>
>>>>>>>>
>>>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>>>> news:fd8mvj$rfr$1@build.eclipse.org...
>>>>>>>>> Venc,
>>>>>>>>>
>>>>>>>>> Look at this entry.
>>>>>>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=151427
>>>>>>>>>
>>>>>>>>> Jason
>>>>>>>>>
>>>>>>>>> venc wrote:
>>>>>>>>>> Hi jason,
>>>>>>>>>> Thanks for quick response. Is there bugzilla entry for this?
>>>>>>>>>> Also will there be another patch release to 2.1.3. This seems a
>>>>>>>>>> critical and fundamental performance issue. I'm not sure if this
>>>>>>>>>> is with other data sources as well.
>>>>>>>>>>
>>>>>>>>>> "Jason Weathersby" <jasonweathersby@alltel.net> wrote in message
>>>>>>>>>> news:fd0qrh$7lu$1@build.eclipse.org...
>>>>>>>>>>> Venc,
>>>>>>>>>>>
>>>>>>>>>>> I believe this is a known issue. Should be corrected soon. One
>>>>>>>>>>> work around might be to load a hash with your result sets and
>>>>>>>>>>> then check the hash the second time the script runs.
>>>>>>>>>>>
>>>>>>>>>>> Jason
>>>>>>>>>>>
>>>>>>>>>>> venc wrote:
>>>>>>>>>>>> Hi david/jason,
>>>>>>>>>>>> I have a report with chart designed using scripted data source
>>>>>>>>>>>> (POJO). For some strange reason, its executing the pojo method
>>>>>>>>>>>> twice and this results to querying database twice.
>>>>>>>>>>>>
>>>>>>>>>>>> I'm using BIRT 2.1.3 and this is line chart.
>>>>>>>>>>>>
>>>>>>>>>>>> Please let me know.
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks
>>
>
>
|
|
|
Goto Forum:
Current Time: Fri Jul 18 18:22:04 EDT 2025
Powered by FUDForum. Page generated in 0.06776 seconds |
Home