This might also help : http://www.theserverside.com/discussions/thread.tss?thread_id=29792
Core J2EE Patterns - Value List Handler http://java.sun.com/blueprints/corej2eepatterns/Patterns/ValueListHandler.html -- Cheers, John > > > hai, > > this is lakshmikanth, i am trying to retrieve 10,000 rows from emp table > by using > > ResultSet obj in java,but it displays an errormsg > > i.e OutofMemoryError . > > ow can solve the problem,plz suggest me to retrive 10,000 rows from > database table. > > > > thanks, > > m.lakshmikanth. > >

