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:paul@(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: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)