aspose file tools*
The moose likes JDBC and the fly likes CachedRowSet - Can't get an instance Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "CachedRowSet - Can Watch "CachedRowSet - Can New topic
Author

CachedRowSet - Can't get an instance

Kevin Kruse
Greenhorn

Joined: Jan 11, 2004
Posts: 3
There are many examples of how to use sun.jdbc.RowSet.CashedRowSet along with links to where to get the supporting jar file. However the newer rowset.jar files that I can find at the sun web site don't work with these examples. At the bottom of this post are the links to the early reference download for rowset.jar that I used and a couple of articles that I am talking about.
The problem is that I can't get an instance of CashedRowSet.
The following is a code snippet:
import java.sql.*;
import javax.sql.*;
import sun.jdbc.rowset.*;
...
...
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
CachedRowSet crs = new CachedRowSet();
crs.populate(rs);
rs.close();
conn.close();

It throws the exception: "javax.sql.rowset.CachedRowSet is abstract; cannot be instantiated."
Obviously with so many articles and examples out there it used to work.
Can anyone help ?
Articles:
"Get disconnected with CachedRowSet"
http://java.sun.com/developer/technicalArticles/javaserverpages/cachedrowset/
jGuru Q&A
http://www.jguru.com/faq/view.jsp?EID=776543
Early Access JDBC Rowset Implementations
http://java.sun.com/developer/earlyAccess/jdbc/jdbc-rowset.html
Sergiu Truta
Ranch Hand

Joined: Dec 16, 2003
Posts: 121
post your email and I can send a jar that contains the implementation for CachedRowSet. I have faced this problem myself couple of months ago but eventually found a good jar.


...watch me...as I'm walking the path...
Kevin Kruse
Greenhorn

Joined: Jan 11, 2004
Posts: 3
I am so happy to hear from you and that you have a rowset.jar file for me!
Please send it to krusek@comcast.net
This is Great!
Thanks you!
Kevin Kruse
Chris Mathews
Ranch Hand

Joined: Jul 18, 2001
Posts: 2712
Moving to the JDBC Forum...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: CachedRowSet - Can't get an instance