If you create a 2nd ResultSet using the same Statement instance then the previous ResultSet is automically closed. To get around this feature use 2 Statement instances to create the 2 ResultSets that you want to iterate through.
Post by:autobot
snakes are really good at eating slugs. And you wouldn't think it, but so are tiny ads:
a bit of art, as a gift, that will fit in a stocking