Originally posted by Ann Maria: Can we combine resultsets into a single resultset? If possible, how?
construct two dimensional object array(Object) from the individual ResultSet and merge the tow arrays. Or you can use Collection. keeping two different ResultSet is not a good idea becuase unless you close the ResultSet it still attached to the Connection. By the way you can modify your SQL to get everything in one single ResultSet probably you can use SQL JOIN.
I'll toss out an ancient algorithm I learned when merging stacks of punch cards. This assumes data is sorted on some kind of key we can match between the two datasets:
Can you imagine your merge now? What do you do when a key is in one result set but not the other ... add it to the output set? What do you do when a key is in both input sets ... use data from one or the other or do they maybe have different columns?
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
I would note that the original post was ten days ago, and Jesper's response asked the critical question: what are you trying to achieve? There's been no response since then. I would suggest that there's little point offering a bunch more questions and suggestions if she's not following up.
"I'm not back." - Bill Harding, Twister
In the renaissance, how big were the dinosaurs? Did you have tiny ads?
Devious Experiments for a Truly Passive Greenhouse!