I am working on an academic distributed database project. I will appreciate if someone can give me advice on this.
I receive a distributed query from user and gather the required data from nodes. Now I want to put it in a Resultset and pass it to the user (so that he can iterate over it etc.).
1- Is it possible in a simple way to use JDBC's Resultset object to encapsulate my data and pass it to the user in response to his distributed query or I should rather use my own custom structures?
2- Java's Resultset object needs a live connection even if I already have all the records available (limited set) ? In my current solution each query fetches all the needed rows (I assume limited number of rows) from different nodes and combines them in an array. Is it possible to use Resultset without involving an open Connection object to pass this information?
Thank you very much for your help.
Regards, Mac [ March 05, 2008: Message edited by: Siamak Saarmann ]