> 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
