This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
it is *usually* common practice to have many nested resultsets, each with their own Statement. I say *usually* because there are some substandard JDBC drivers that are also limited to 1 Statement to 1 Connection ! So check to make sure that your driver can handle multiple Statements for each Connection then query away! Jamie