What in the heck are you talking about? The example code doesn't reuse a ResultSet object...each executeQuery call returns a new ResultSet object.
OK, now we're WAY off topic. Allen > -----Original Message----- > From: Mike Curwen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 01, 2003 9:58 AM > To: 'Tomcat Users List' > Subject: RE: [OFF-TOPIC] RE: can resultset object be re-used > > > Well I just gotta say that's not true. You *can* re-use a resultset > object. > > ResultSet rs = st.executeQuery("SELECT * FROM FOO"); > //code that loops over rs and outputs results... > rs = st.executeQuery("SELECT * FROM BAR"); > //a re-used ResultSet object. > > > > -----Original Message----- > > From: Shapira, Yoav [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 01, 2003 7:44 AM > > To: Tomcat Users List > > Subject: [OFF-TOPIC] RE: can resultset object be re-used > > > > > > > > Howdy, > > First, this is off-topic and should be marked as such. > > > > Second, the answer is no: you can't reuse them, it's one per > > query. In fact, since ResultSet is an interface, you don't > > even have a constructor you can use (although you could > > always try to reflect the implementation). > > > > Yoav Shapira > > Millennium ChemInformatics > > > > > > >-----Original Message----- > > >From: Paul [mailto:[EMAIL PROTECTED] > > >Sent: Tuesday, September 30, 2003 4:21 PM > > >To: Tomcat Users List > > >Subject: can resultset object be re-used > > > > > >jdbc question (tomcat 4.x, java 1.4.2, jdbc 3.0): > > > > > >can the ResultSet object be re-used to retrieve results from > > altogether > > >different sql query in same .jsp page? Or does a new > > ResultSet object > > need > > >to be created for each distinct sql query? > > > > > >-paul lomack. > > > > > > > > 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] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
