| Simple Grouping problem [message #48664] |
Tue, 21 June 2005 11:06  |
Eclipse User |
|
|
|
Originally posted by: pavlov.clockbs.com
Hi to all,
I am impresses by the BIRT project and impatient to evaluate it for
inclusion in our new projects. I have very few knowledge about it, so
please excuse my stupid mistakes if any.
After I successfully launched my first report with ScriptedDataSet I
decided to group it by the first field. immediately I received
"Error1:Failed to render Table".
Where can I read more about grouping definition?
Thank you.
Veselin Pavlov
|
|
|
|
|
|
|
|
| Re: Simple Grouping problem [message #54776 is a reply to message #54327] |
Thu, 07 July 2005 07:52  |
| Eclipse User |
|
|
|
Ok, now everything is working I did some benchmarking, and unfortunately the
results are very bad. So bad that I have to abandon my solution reusing the
Hibernate POJOS and use plain old boring JDBC after all!
I got a Collection with 4000 'complex' objects and I copy the values from
the Java Objects into the javascript data set rows like this;
while (results.hasNext()){
Employee emp = results.next();
row.name = emp.name;
row.department = ""+emp.position.unity.process.description;
/*
(equivalent to;
row.department = "" +
emp.getPosition().getUnity().getProcess().getDescription();
*/
}
In the report I do a grouping on row.department.
But this process of copying the values in Javascript variables takes about 3
minutes (PIII, 850Mhz)!
Make the report with JDBC, so without the need to do this while loop,
executes immediately!
"Stavros Kounis" <gounis@clubmobil.com> wrote in message
news:daghbr$6ab$1@news.eclipse.org...
> Hi Paul
>
> i see that you (finally) have find a solution (you are fast). can you
> please add this in your comment in my blog entry [1]?
>
> [1] http://tools.osmosis.gr/blog/archives/2005/06/birt_and_objec t.html
>
> thnx
>
> stavros
>
> "Paul Kuit" <paul.kuit@comsol.com.br> wrote in message
> news:daeead$t3h$1@news.eclipse.org...
>> Found a solution..
>>
>> The object assigned to the field in the data set was a Java String, which
>> is implemented as this NativeJavaObject?
>>
>> So when I made a new String inside the fetch method of the DataSet
>> JavaScript
>>
>> row["foo"] = ""+foo.getValue();
>>
>> the String would be able to be compared.
>>
>>
>>
>> "Paul Kuit" <paul.kuit@comsol.com.br> wrote in message
>> news:dadt8e$4ep$1@news.eclipse.org...
>>> Having the exact same problem...
>>>
>>> The logs tell me there is a ClassCastException during a compare, but the
>>> group by value is a String Object.
>>>
>>> When I change the output column type to String instead of Any, the
>>> report renders, but shows me the object representation String instead of
>>> it
|
|
|
| Re: Simple Grouping problem [message #55232 is a reply to message #54776] |
Fri, 08 July 2005 07:54 |
| Eclipse User |
|
|
|
I found a workaround to still use Hibernate with better performance;
I am writing a csv results set file from the hibernate objects and use the
data through a flat file data source.
I
|
|
|
Powered by
FUDForum. Page generated in 0.06116 seconds
Home