Howdy, >root cause > >java.lang.OutOfMemoryError > > >It happens When the corresponding request returns more than 20000-30000 >rows from the database, not every time
Perhaps you should allocate your JVM more memory, by using the Java -Xmx parameter. Alternatively, consider a system design that retrieves a smaller, fixed number of rows instead of "20000-30000" and lets the user scroll, say 100 rows at a time. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]