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
posted 10 years ago
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......