There are many potential solutions to this, but one is to figure out what the end result of iterating through your result set is, then create a stored procedure to do the same thing.
Bryan ----- Original Message ----- From: "Michael Lee" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 9:42 AM Subject: Re: [FRIDAY] Out of control ... again [OT] [HELP] [LOTS OF POSTINGS LITTLE HELP] Hey, do any of you [FRIDAY] guys know how to handle iterating through enourmously large result sets without storing the ResultSet object in memory? I use JDBC cursors now but have to do the query upon each 'next' or 'previous'. I always ask the tough questions that get few responses! :) Mike Lee ----- Original Message ----- From: "James Mitchell" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, September 06, 2002 11:45 AM Subject: RE: [FRIDAY] Out of control ... again > LMAO > > James Mitchell > Software Engineer\Struts Evangelist > Struts-Atlanta, the "Open Minded Developer Network" > http://www.open-tools.org/struts-atlanta > > > > > > -----Original Message----- > > From: Chappell, Simon P [mailto:[EMAIL PROTECTED]] > > Sent: Friday, September 06, 2002 11:41 AM > > To: Struts Users Mailing List > > Subject: RE: [FRIDAY] Out of control ... again > > > > > > Well said Sheriff Eddie! > > > > I hereby promise [hand placed upon a stack of printed Struts > > articles] to be a good Struts mailing list user and to use my > > power for good and not evil. So help me Craig! :-) > > > > Simon > > > > ----------------------------------------------------------------- > > Simon P. Chappell [EMAIL PROTECTED] > > Java Programming Specialist www.landsend.com > > Lands' End, Inc. (608) 935-4526 > > > > > > >-----Original Message----- > > >From: Eddie Bush [mailto:[EMAIL PROTECTED]] > > >Sent: Friday, September 06, 2002 10:36 AM > > >To: Struts Users List > > >Subject: [FRIDAY] Out of control ... again > > > > > > > > >Guys, > > > > > >I enjoy (part of) your postings just as much as you intended > > >them to be > > >enjoyed. However, it seems we're headed down that dark, lonely > > >alley-way again. Ok, ok ... I chipped in on the crap myself, > > >so I guess > > >I don't have full right to say anything. However, if you > > >value the list > > >and wish to see us being able to continue with our "relaxed friday" > > >attitude, I strongly urge you to cut out the entirely > > >inappropriate crap > > >that has started to be slung around today. > > > > > >You all know I'm not for cutting out all the [OT] and [FRIDAY] stuff, > > >but I have to agree with folks that say part of what has been posted > > >today is uncalled for and entirely inappropriate for public > > >consumption. > > > > > >Bear in mind what we learned from the recent poll: > > > * Most folks enjoy the [OT] stuff > > > * Many folks would prefer any [OT] stuff be more closely confined > > >to technically-oriented topics > > > * Several would like to make note that beer is not a worthy topic > > >for discussion > > > > > >I think if we keep those points in mind, all of us will be able to get > > >along just fine. If we find ourselves driven to "think > > >outside the box" > > >(wrt these points), I think we'll find that the minority > > >numbers we saw > > >dislikeing the [OT] posts will quickly become a majority. Thereafter, > > >the list will (out of necessity) become much more rigid. I > > >don't think > > >any of us want this. Can we *please* act like adults? > > > > > >Personally, I enjoyed (a few of) the posts this morning. However, > > >posting sites with sexually-explicit material - that comes with pop-up > > >pages of all sorts of things! - and trying to belittle people doesn't > > >seem appropriate for this list IMNSHO. Many of us are in public areas > > >where things like the first could get us into serious trouble. The > > >second is just ... wrong. > > > > > >Regards, > > > > > >Eddie > > > > > > > > > > > >-- > > >To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:[EMAIL PROTECTED]> > > For additional commands, e-mail: > > <mailto:[EMAIL PROTECTED]> > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>