Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes Combining 2 disparate ResultSets 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 "Combining 2 disparate ResultSets" Watch "Combining 2 disparate ResultSets" New topic

Combining 2 disparate ResultSets

Chinmay Bajikar
Ranch Hand

Joined: Dec 08, 2001
Posts: 159
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.


The strength of the Wolf is the pack & the strength of the pack is the wolf....Rudyard Kipling
Karthik Banda

Joined: Oct 24, 2002
Posts: 9
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.

Sun Certified Java Programmer<br />Sun Certified Web Component Developer <br />Sun Certified Business Component Developer<br />BEA Certified Weblogic Server Specialist<br /> <br />Never Stop Questioning......
I agree. Here's the link:
subject: Combining 2 disparate ResultSets
It's not a secret anymore!