GeeCON Prague 2014*
The moose likes JDBC and the fly likes CachedRowSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "CachedRowSet" Watch "CachedRowSet" New topic
Author

CachedRowSet

Arjunkumar Shastry
Ranch Hand

Joined: Feb 28, 2005
Posts: 986
Is it true that Microsoft SQL server/driver does not support JDBC RowSet implmentation?


Namma Suvarna Karnataka
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

I dont think that drivers are required to support it. There is a reference implemenation from Sun.


Groovy
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0406bhogal/

This article mentions that there in only one implementation of CachedRowSet. The package is javax.sql and not java.sql.

Looks like your database has millions of rows.
Arjunkumar Shastry
Ranch Hand

Joined: Feb 28, 2005
Posts: 986
Yes,I am using the same but following lines of code give runtime error that Datasource can not be found.

There are two similar tables(with same columns).I want to fetch few records from one table and insert them into another table.
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

The thread subject says "CachedRowSet" by why are using JDBCRowSet ?
Arjunkumar Shastry
Ranch Hand

Joined: Feb 28, 2005
Posts: 986
OK how to insert rows using CachedRowSetImpl? I am comfortable with anyone.
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

Put the stack trace here otherwise it is difficult to point out the error with the code snippet provided.
Arjunkumar Shastry
Ranch Hand

Joined: Feb 28, 2005
Posts: 986
Error is at unknown datasource.
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919



I seriously doubt if you can populate a cachedrow with result set of one table and update a another table.
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8919

From the CachedRowSet API

An application can modify the data in a CachedRowSet object, and those modifications can then be propagated back to the source of the data.

 
GeeCON Prague 2014
 
subject: CachedRowSet