This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 565
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: CachedRowset - Relaiable to use??
 
Similar Threads
how to read few records at a time?
Performace of accessing db recs
CachedRowSet with JSF
accessing resultSet
ResultSet vs RowSet