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.

Andy Bowes<br />SCJP, SCWCD<br />I like deadlines, I love the whoosing noise they make as they go flying past - Douglas Adams