Can u tell me exactly whats the concept of using CRS..What i understood is with normal ResultSet the connection to DataBase is maintained ..SO i am utilizing the coonection irresoective of any needs..where as in CRS i retrieve the record adn the connection is released to connection Pool.
If this is the reason wasnt this basic requirement taken care before
second advantage is U can update the result set in CSR and then after u have made all the changes u can update it in the backend...unlike in ResultSet where i need to write SQL query..
Are there any other advantage..Am i getting the concept right
Please read the following article for more info:
Get disconnected with CachedRowSet in Java World Feb 2001
You can access it on-line at this url: