Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

nested result sets

 
Anthony Smith
Ranch Hand
Posts: 285
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic