File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes nested result sets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "nested result sets" Watch "nested result sets" New topic

nested result sets

Anthony Smith
Ranch Hand

Joined: Sep 10, 2001
Posts: 285
Can this not be done and given correct info?
I have even tried makign each result set be called by its own Statement. Any ideas? Should this be avoided?
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

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!
I agree. Here's the link:
subject: nested result sets
It's not a secret anymore!