help big table display！

[stamilo]

hi，
  i have a big table ,about 10,000 rows data ,
  i use

    <form name="LOGList" type="list" list-name="examples"
paginate-target="LOGList">
        <actions>
            <entity-condition entity-name="TLog"><order-by
field-name="fKey"/></entity-condition>
        </actions>
  that , want do display data , but nothing showed ,
  console report  :
      [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
[StandardWrapperValve.
java:274:ERROR] Servlet.service() for servlet ControlServlet threw exception
     [java] java.lang.OutOfMemoryError: Java heap space

how  i can display the big table ?

 thx!

[Rochi Febo Dommarco]

Hi,

if you not already done it, and if you have enough memory you can
increase the maximum heap size.
You can replace -Xmx512M (files startup.sh or startup.bat) with
-Xmx1024M for example.

Regards,
-rochi

On Wed, 2008-06-25 at 10:46 +0800, stamilo wrote:

> hi，
>   i have a big table ,about 10,000 rows data ,
>   i use
>
>     <form name="LOGList" type="list" list-name="examples"
> paginate-target="LOGList">
>         <actions>
>             <entity-condition entity-name="TLog"><order-by
> field-name="fKey"/></entity-condition>
>         </actions>
>   that , want do display data , but nothing showed ,
>   console report  :
>       [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
> [StandardWrapperValve.
> java:274:ERROR] Servlet.service() for servlet ControlServlet threw exception
>      [java] java.lang.OutOfMemoryError: Java heap space
>
> how  i can display the big table ?
>
>  thx!

[stamilo]

thank you,

but it's very slowly, do you have any another ideal ?

there are 100,000 rows record in my table  :)



On Wed, Jun 25, 2008 at 11:23 AM, Rochi Febo Dommarco <[hidden email]>
wrote:

> Hi,
>
> if you not already done it, and if you have enough memory you can
> increase the maximum heap size.
> You can replace -Xmx512M (files startup.sh or startup.bat) with
> -Xmx1024M for example.
>
> Regards,
> -rochi
>
> On Wed, 2008-06-25 at 10:46 +0800, stamilo wrote:
> > hi，
> >   i have a big table ,about 10,000 rows data ,
> >   i use
> >
> >     <form name="LOGList" type="list" list-name="examples"
> > paginate-target="LOGList">
> >         <actions>
> >             <entity-condition entity-name="TLog"><order-by
> > field-name="fKey"/></entity-condition>
> >         </actions>
> >   that , want do display data , but nothing showed ,
> >   console report  :
> >       [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
> > [StandardWrapperValve.
> > java:274:ERROR] Servlet.service() for servlet ControlServlet threw
> exception
> >      [java] java.lang.OutOfMemoryError: Java heap space
> >
> > how  i can display the big table ?
> >
> >  thx!
>
>

[David E Jones]

Look at the definition of the entity-condition action's XML element to  
see what your options are.

There are some sub-elements called limit-range, limit-view, and use-
iterator that will help with this.

To understand this better check out the EntityListIterator class,  
related documentation, and examples of how it is used.

-David


On Jun 24, 2008, at 9:53 PM, stamilo wrote:

> thank you,
>
> but it's very slowly, do you have any another ideal ?
>
> there are 100,000 rows record in my table  :)
>
>
>
> On Wed, Jun 25, 2008 at 11:23 AM, Rochi Febo Dommarco <[hidden email]
> >
> wrote:
>
>> Hi,
>>
>> if you not already done it, and if you have enough memory you can
>> increase the maximum heap size.
>> You can replace -Xmx512M (files startup.sh or startup.bat) with
>> -Xmx1024M for example.
>>
>> Regards,
>> -rochi
>>
>> On Wed, 2008-06-25 at 10:46 +0800, stamilo wrote:
>>> hi，
>>>  i have a big table ,about 10,000 rows data ,
>>>  i use
>>>
>>>    <form name="LOGList" type="list" list-name="examples"
>>> paginate-target="LOGList">
>>>        <actions>
>>>            <entity-condition entity-name="TLog"><order-by
>>> field-name="fKey"/></entity-condition>
>>>        </actions>
>>>  that , want do display data , but nothing showed ,
>>>  console report  :
>>>      [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
>>> [StandardWrapperValve.
>>> java:274:ERROR] Servlet.service() for servlet ControlServlet threw
>> exception
>>>     [java] java.lang.OutOfMemoryError: Java heap space
>>>
>>> how  i can display the big table ?
>>>
>>> thx!
>>
>>

[stamilo]

thanks!!!



On Wed, Jun 25, 2008 at 11:58 AM, David E Jones <[hidden email]>
wrote:

>
> Look at the definition of the entity-condition action's XML element to see
> what your options are.
>
> There are some sub-elements called limit-range, limit-view, and
> use-iterator that will help with this.
>
> To understand this better check out the EntityListIterator class, related
> documentation, and examples of how it is used.
>
> -David
>
>
>
> On Jun 24, 2008, at 9:53 PM, stamilo wrote:
>
>  thank you,
>>
>> but it's very slowly, do you have any another ideal ?
>>
>> there are 100,000 rows record in my table  :)
>>
>>
>>
>> On Wed, Jun 25, 2008 at 11:23 AM, Rochi Febo Dommarco <[hidden email]>
>> wrote:
>>
>>  Hi,
>>>
>>> if you not already done it, and if you have enough memory you can
>>> increase the maximum heap size.
>>> You can replace -Xmx512M (files startup.sh or startup.bat) with
>>> -Xmx1024M for example.
>>>
>>> Regards,
>>> -rochi
>>>
>>> On Wed, 2008-06-25 at 10:46 +0800, stamilo wrote:
>>>
>>>> hi，
>>>>  i have a big table ,about 10,000 rows data ,
>>>>  i use
>>>>
>>>>   <form name="LOGList" type="list" list-name="examples"
>>>> paginate-target="LOGList">
>>>>       <actions>
>>>>           <entity-condition entity-name="TLog"><order-by
>>>> field-name="fKey"/></entity-condition>
>>>>       </actions>
>>>>  that , want do display data , but nothing showed ,
>>>>  console report  :
>>>>     [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
>>>> [StandardWrapperValve.
>>>> java:274:ERROR] Servlet.service() for servlet ControlServlet threw
>>>>
>>> exception
>>>
>>>>    [java] java.lang.OutOfMemoryError: Java heap space
>>>>
>>>> how  i can display the big table ?
>>>>
>>>> thx!
>>>>
>>>
>>>
>>>
>

[Vikas Mayur-2]

Instead of list, use EntityListIterator like

        <entity-condition entity-name="TLog" list-name="TLogs">
            <use-iterator/>
        </entity-condition>


- Vikas

On Wed, Jun 25, 2008 at 8:16 AM, stamilo <[hidden email]> wrote:

> hi，
>  i have a big table ,about 10,000 rows data ,
>  i use
>
>    <form name="LOGList" type="list" list-name="examples"
> paginate-target="LOGList">
>        <actions>
>            <entity-condition entity-name="TLog"><order-by
> field-name="fKey"/></entity-condition>
>        </actions>
>  that , want do display data , but nothing showed ,
>  console report  :
>       [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
> [StandardWrapperValve.
> java:274:ERROR] Servlet.service() for servlet ControlServlet threw
> exception
>     [java] java.lang.OutOfMemoryError: Java heap space
>
> how  i can display the big table ?
>
>  thx!
>

[Ashish Vijaywargiya]

Vikas,

If you will noticed David has alread mentioned it in another thread which is
generated from this topic :-).
Although Stamilo will be double happy to see double reply of his email :-)

--
Ashish


2008/6/25 Vikas Mayur <[hidden email]>:

> Instead of list, use EntityListIterator like
>
>        <entity-condition entity-name="TLog" list-name="TLogs">
>            <use-iterator/>
>        </entity-condition>
>
>
> - Vikas
>
> On Wed, Jun 25, 2008 at 8:16 AM, stamilo <[hidden email]> wrote:
>
> > hi，
> >  i have a big table ,about 10,000 rows data ,
> >  i use
> >
> >    <form name="LOGList" type="list" list-name="examples"
> > paginate-target="LOGList">
> >        <actions>
> >            <entity-condition entity-name="TLog"><order-by
> > field-name="fKey"/></entity-condition>
> >        </actions>
> >  that , want do display data , but nothing showed ,
> >  console report  :
> >       [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
> > [StandardWrapperValve.
> > java:274:ERROR] Servlet.service() for servlet ControlServlet threw
> > exception
> >     [java] java.lang.OutOfMemoryError: Java heap space
> >
> > how  i can display the big table ?
> >
> >  thx!
> >
>

[stamilo]

thx,
 i'm very happy, haha
 :) :)

2008/6/25 Ashish Vijaywargiya <[hidden email]>:

> Vikas,
>
> If you will noticed David has alread mentioned it in another thread which
> is
> generated from this topic :-).
> Although Stamilo will be double happy to see double reply of his email :-)
>
> --
> Ashish
>
>
> 2008/6/25 Vikas Mayur <[hidden email]>:
>
> > Instead of list, use EntityListIterator like
> >
> >        <entity-condition entity-name="TLog" list-name="TLogs">
> >            <use-iterator/>
> >        </entity-condition>
> >
> >
> > - Vikas
> >
> > On Wed, Jun 25, 2008 at 8:16 AM, stamilo <[hidden email]> wrote:
> >
> > > hi，
> > >  i have a big table ,about 10,000 rows data ,
> > >  i use
> > >
> > >    <form name="LOGList" type="list" list-name="examples"
> > > paginate-target="LOGList">
> > >        <actions>
> > >            <entity-condition entity-name="TLog"><order-by
> > > field-name="fKey"/></entity-condition>
> > >        </actions>
> > >  that , want do display data , but nothing showed ,
> > >  console report  :
> > >       [java] 2008-06-25 02:44:17,360 (http-0.0.0.0-8443-2)
> > > [StandardWrapperValve.
> > > java:274:ERROR] Servlet.service() for servlet ControlServlet threw
> > > exception
> > >     [java] java.lang.OutOfMemoryError: Java heap space
> > >
> > > how  i can display the big table ?
> > >
> > >  thx!
> > >
> >
>