File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes CachedRowset - Relaiable to use?? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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
posted private message
0
Quote
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: 564
posted
0
Quote
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.
 
I agree. Here's the link: jrebel
 
subject: CachedRowset - Relaiable to use??
 
Similar Threads
how to read few records at a time?
accessing resultSet
CachedRowSet with JSF
Performace of accessing db recs
ResultSet vs RowSet