Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes CachedRowset - Relaiable to use?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CachedRowset - Relaiable to use??" Watch "CachedRowset - Relaiable to use??" New topic
Author

CachedRowset - Relaiable to use??

Vaibhav Deshpande
Ranch Hand

Joined: Apr 26, 2002
Posts: 33
Hi,
I want to know cachedRowset is reliable to use with complex quries.In case of cachedRowset update and insert happens in rowset set itself or in database.

vaibhav
Adam Hardy
Ranch Hand

Joined: Oct 09, 2001
Posts: 566
Originally posted by Vaibhav Deshpande:
I want to know cachedRowset is reliable to use with complex quries.In case of cachedRowset update and insert happens in rowset set itself or in database.


Are you asking about update and inserts in a disconnected / cached set? If so, sorry but I've not tried using a CachedRowSet while disconnected to add or update records. I used it purely for select queries, for which it is totally reliable.
Adam


I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: CachedRowset - Relaiable to use??