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]
