I have a search screen in my servlet to search by name. This search is done on three different dbs using three different connections, retrieving three different ResultSets. No problem there. The problem lies in the fact that thousands of records are possible so I set it up to do paging (10 results per page)I have this working when searching one datasource using 1 ResultSet. I am stumped on how I can do this with all three. Is there some way to combine ResultSets?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple Sources for ResultSets
- Thread starter donniea21
- Start date