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.