Look at the scrollable result set. This allows you to, after you have gotten your result set, advance the cursor to any point in the set. As you are working with a cursor, the data is not really trnsfered until you get the data from the cursor. http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/cursor.html
--- "Conway. Fintan (IT Solutions)" <[EMAIL PROTECTED]> wrote: > Hi Lydia, > > Unfortunately, I have not received any replies on this. > > As far as I understand the design pattern (Page-by-Page iterator) > does not specify how to split up the data you receive from the database into > ListChunks. > > Does anybody have any concrete strategies for this? (Whether used > with the page-by-page iterator or not) > > Thanks for your help, > > Fintan > > PS I am using Oracle DB if DB-specific solution is required > > -----Original Message----- > From: Lydia P [mailto:[EMAIL PROTECTED]] > Sent: 20 November 2002 19:02 > To: [EMAIL PROTECTED] > Subject: [jdjlist] RE: Performance Issues > > > Hi there, did you ever get an answer to this question? > I have the same question. I am having a really hard time finding a way > to get 'chunks' at a time of my list to display - I saw the ListChunk as > well but have no idea what to do with it (can you tell im pretty new at > this?) > I have a DAO, VO/TO, ServiceLocator and an Action class and I have a jsp > that uses struts/tiles and actually does return a very long list of > data, so I really do need to break it up into pages. > > Any help you can give me would be greatly appreciated! > Thanks, > Lydia P > > > > > Can anybody explain how the Page-by-Page iterator works. > > > > I am not using EJB's and the Sun PetStore example boils down a ListChunk > > class. This class retrieves the data from the database in Chunks, but how > > this is done is not explained anywhere that I can find. > > > > Can anyone enlighten me on this issue? > > > > Many thanks, > > > > Fintan > > > > * ** *** ** * ** *** ** * ** *** ** * > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. > Any views or opinions presented are solely those of the author, and do not >necessarily > represent those of ESB. > If you have received this email in error please notify the sender. > > Although ESB scans e-mail and attachments for viruses, it does not guarantee > that either are virus-free and accepts no liability for any damage sustained > as a result of viruses. > > * ** *** ** * ** *** ** * ** *** ** * > > ____________________________________________________ > To change your JDJList options, please visit: > http://www.sys-con.com/java/list.cfm > > Be respectful! Clean up your posts before replying > ____________________________________________________ ===== Mark Zawadzki Performance Engineer/DBA/Programmer extraordinaire� [EMAIL PROTECTED] [EMAIL PROTECTED] "Democracies die behind closed doors," - Judge Damon Keith "The people of this country, not special interest big money, should be the source of all political power. Government must remain the domain of the general citizenry, not a narrow elite." - Sen. Paul Wellstone __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus � Powerful. Affordable. Sign up now. http://mailplus.yahoo.com ____________________________________________________ To change your JDJList options, please visit: http://www.sys-con.com/java/list.cfm Be respectful! Clean up your posts before replying ____________________________________________________
