• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Combining 2 disparate ResultSets

 
Chinmay Bajikar
Ranch Hand
Posts: 159
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey guys,
I was wondering if we can combine 2 resultsets into one common resultset.
I have 2 resultsets (similar in structure)coming from 2 diff db's and would want to combine them, which will make my task a lot easier.

Thanks,
Chinmay...
 
Karthik Banda
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Each ResultSet object holds a refernce back to a cursor in a table and when we iterate through it, it points to a specific record in in the iteration. So logically it makes no sense even to combine two ResultSets and perhaps, there is no method in the API to allow you to do it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic