out of memory error

> Hi,
>
>
>
> I'm running
>
>
>
> Orbeon Forms 3.5.1.200704101641
>
>
>
> I've got a simple app based upon the sql address book that displays some
> RADIUS accounting statistics for our dialin,  wireless and wired 802.1X
> users.
>
> It displays a table of the users currently on line along with the start
> time, session time and the amount of data transferred.
>
>
>
> The app works just fine...   well at least it did till our the number of
> records to display reached 8000!!. At this point attempting to use the
> app results in the browser hanging ( waiting for a response from the
> server) and eventually timing out.
>
>
>
> Deleting a large proportion of the db records "fixed" the problem and
> the app worked again.
>
>
>
> Below is the associated log4j.log.output.  Would the easiest way of
> dealing with this be to implement some form of paging display where the
> user see 10 or 15 records and has a next/prev set of buttons to browse
> through the data?  I'm also thinking of adding some sort of search
> criteria e.g. only show dial in, wired or wireless to cut down the
> number of records displayed.
>
>
>
> Alex
>
>
>
> 2007-05-23 14:30:23,234 [resin-tcp-connection-*:80-11] DEBUG - Execute
> row: rowNum = 2364
>
> 2007-05-23 14:30:33,235 [resin-tcp-connection-*:80-11] INFO - Rolling
> back JDBC connection for datasource: jdbc/radSupport.
>
> 2007-05-23 14:30:33,239 [resin-tcp-connection-*:80-11] ERROR - Exception
> with no location data
>
> java.lang.OutOfMemoryError: allocLargeArray - Object size: 1191488, Num
> elements: 297868
>
>         at java.util.ArrayList.ensureCapacity(ArrayList.java:169)
>
>         at java.util.ArrayList.add(ArrayList.java:351)
>
>         at org.orbeon.oxf.xml.SAXStore.endElement(SAXStore.java:279)
>
>         at
> org.orbeon.oxf.xml.ForwardingContentHandler.endElement(ForwardingContent
> Handler.java:52)
>
>         at
> org.orbeon.oxf.xml.DeferredContentHandlerImpl.endElement(DeferredContent
> HandlerImpl.java:65)
>
>         at
> org.orbeon.oxf.processor.sql.SQLProcessor$ForwardingContentHandler.endEl
> ement(SQLProcessor.java:634)
>
>         at
> org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endE
> lement(SQLProcessor.java:544)
>
>         at
> org.orbeon.oxf.processor.sql.interpreters.RowIteratorInterpreter.endElem
> ent(RowIteratorInterpreter.java:196)
>
>         at org.orbeon.oxf.xml.SAXStore.replay(SAXStore.java:173)
>
>         at
> org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.repe
> atBody(SQLProcessor.java:551)
>
>         at
> org.orbeon.oxf.processor.sql.interpreters.RowIteratorInterpreter.start(R
> owIteratorInterpreter.java:95)
>
>         at
> org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endE
> lement(SQLProcessor.java:531)
>
>         at org.orbeon.oxf.xml.SAXStore.replay(SAXStore.java:173)
>
>         at
> org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.repe
> atBody(SQLProcessor.java:551)
>
>         at
> org.orbeon.oxf.processor.sql.interpreters.ResultSetInterpreter.start(Res
> ultSetInterpreter.java:77)
>
>         at
> org.orbeon.oxf.processor.sql.SQLProcessor$InterpreterContentHandler.endE
> lement(SQLProcessor.java:531)
>
> *****************************************************************************************
> To view the terms under which this email is distributed, please go to
> http://www.hull.ac.uk/legal/email_disclaimer.html
> *****************************************************************************************