• 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.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!