setStartAtIndex/setEndAtIndex for a very large result set

[ZZZ Liu <z2...@yahoo.com>]

Hi, All

I am trying to do a simple query against a very large
table with over 200,000 records. I use QueryByCriteria
without any criteria, but settiing setStartAtIndex(1)
and setEndAtIndex(2). Then I use getIteratorByQuery to
get the result. However, I got OutOfMemory error.

I tried the same thing on a relatively small table
(about 100 records) and it works fine.

Could anybody shed some light on this?

Thanks,
Zhe

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org