amitku26

 Profile Answers by amitku26 

• Feb 7th, 2006

 

By using ResultSet, We have to open up the connection untill the fetching of data. But it is not with the case of rowset. because by using the concept of chaceRowset we fetch the record into the memory, close the connection and use the memory for further need.

unknown

• Feb 7th, 2006

 

the ResultSet is closed as soon as the Statement itself is closed, or used to retrieve another ResultSet. Therefore, the pointer that once provided a handle to the query results is no longer valid, and this is where CachedRowSet comes in. Unlike a ResultSet, a CachedRowSet stores all rows obtained from a query in local memory, which can be extremely convenient at times.

http://www.onjava.com/pub/a/onjava/2004/06/23/cachedrowset.html