This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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......
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Combining 2 disparate ResultSets
 
Similar Threads
Compare 2 Resultsets
How to merge multiple ResultSet to 1
preferred collection class for storing Resultset?
Combine Resultset
Combining Resultsets