[no subject]

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.

This means you can only have one open ResultSet on a given Statement at a 
time which your original coding violates.

Kris Jurka