I am having resultsets obtained from execution of query on two different database connections. i want to work on the two result sets simultaneously. My current condition is the first connection is closed before the execution of the second query. Is there any way where i can store the first resultset without having attachment to any connection?? or can i create a clone for the resultset.
clone method over the object class is having protected access and i am wondering how to proceed.
A CachedRowSet object is a container for rows of data that caches its rows in memory, which makes it possible to operate without always being connected to its data source. Further, it is a JavaBeansTM component and is scrollable, updatable, and serializable. A CachedRowSet object typically contains rows from a result set, but it can also contain rows from any file with a tabular format, such as a spread sheet. The reference implementation supports getting data only from a ResultSet object, but developers can extend the SyncProvider implementations to provide access to other tabular data sources.
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein