Thanks for your reply,
It will work for the hibernate mapped classes only. i written a manual
query for reports for that one how to use this example. (displaytag tutorial
understanding is critical to me please provide me the example if it works
for the manual queries like written below)
Manual Query For reports:
String query = "select HN.hostname As \"Name\", NT.\"date\" As \"Date\",
NT.\"time\" As \"Time\", "+
" NT.bytes As \"Bytes\", NT.url As \"URL\",
NT.resultCode As \"result\""
+
"from traffic NT " +
"JOIN hostnames HN ON (NT.ip=HN.ip AND
HN.hostname='"+hostName+"') " +
"order by NT.\"date\",NT.\"time\" desc";
executes query using: rs = stmt.executeQuery(query);
after that i mapped the columns with the column names and return it as list.
please suggest me how to apply the above pagination technique to this manual
query or suggest me the query implementation technique (it is not related to
the hibernate model classes)
mraible wrote:
>
> If you try to render 50,000 records on any sort of HTML page, it's
> likely to blow up. That's simply too much data, and I doubt your users
> would actually want to view all of it. I'd suggest using the
> pagination feature of the displaytag:
>
> http://displaytag.sourceforge.net/11/tut_externalSortAndPage.html
>
> You might also take a look at this project:
>
> http://code.google.com/p/pagingappfuse/
>
> Matt
>
> On Tue, Oct 6, 2009 at 3:04 AM, sudhakargupta
> <sudhakargupta_s...@hotmail.com> wrote:
>>
>> Hi Matt,
>>
>> Presently i'm working with appfuse 1.9 (struts) application, in my
>> application i need to generate the reports with customized queries which
>> is
>> not related to the hibernate mapped classes. In some situations the query
>> returns 50,000 records or higher (return as a list to use displaytag
>> library
>> to shown), at that moment it gives an error like
>>
>> java.lang.OutOfMemoryError: Java heap space
>>
>> i tried it out with JAVA_OPTS in my environmental variable -Xms128m
>> -Xmx1024m, but it is not given any difference.
>>
>> please suggest me how to avoid the java heap space problem
>>
>> -----
>> ---
>> Sudhakar
>> --
>> View this message in context:
>> http://www.nabble.com/heap-space-error-when-generating-reports.-tp25763835s2369p25763835.html
>> Sent from the AppFuse - User mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
>> For additional commands, e-mail: users-h...@appfuse.dev.java.net
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
> For additional commands, e-mail: users-h...@appfuse.dev.java.net
>
>
>
-----
---
Sudhakar
--
View this message in context:
http://www.nabble.com/heap-space-error-when-generating-reports.-tp25763835s2369p25783752.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@appfuse.dev.java.net
For additional commands, e-mail: users-h...@appfuse.dev.java.net
