I reckon what you feel and what
java does ain't always the same thing. The second call to rs.next() produces the following error:
From the ResultSet API:
"A ResultSet object is automatically closed when the Statement object that generated it is closed,
re-executed, or used to retrieve the next result from a sequence of multiple results."
Therefore when you call the second query on the original statement object, you force the first result set to be closed. Any future calls to the first result set, will produce an error. This does not mean you cannot use the same statement with multiple queries and result set, it just means you have to read the results in the order you execute them. Scattered results, such as those in nested events must be read using separate statements.
[ February 01, 2006: Message edited by: Scott Selikoff ]