> 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. You're not re-using anything here, pal!
"Statement.executeQuery( String query )" *creates* a ResultSet
object. What you've done is create TWO ResultSet object. The
first will be "lost" and caught by the garbage collector (in C++
this would cause memory leak). Nix. ----------------------------
----------------------------------------- To unsubscribe,
e-mail: tomcat-user-unsubscribe@jakarta.apache.org For
additional commands, e-mail: tomcat-user-help@jakarta.apache.org