No. You can re-use the reference to the object (rs), but it refers to a new resultset object created by ExecuteQuery.
Chris -----Original Message----- From: Mike Curwen [mailto:[EMAIL PROTECTED] Sent: 01 October 2003 14:58 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]