*
The moose likes JDBC 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
Bookmark "Combining 2 disparate ResultSets" Watch "Combining 2 disparate ResultSets" New topic
Author

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.

Thanks,
Chinmay...


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

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......
 
wood burning stoves
 
subject: Combining 2 disparate ResultSets
 
Similar Threads
Combining Resultsets
preferred collection class for storing Resultset?
Combine Resultset
Compare 2 Resultsets
How to merge multiple ResultSet to 1