Here is how I used cachedrowset in a jsp page. Don't know whether this will help
<%@ page import="sun.jdbc.rowset.CachedRowSet" %> <HTML> <HEAD> <jsp:useBean id="prversions" class="sun.jdbc.rowset.CachedRowSet" scope="session"> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // initialize our CachedRowSet bean prversions.setUsername("aaa"); prversions.setPassword("bbbb"); prversions.setUrl("jdbc:oracle:thin:@abc:1521:ORCL"); // some drivers require this prversions.setTableName("ONS"); prversions.setCommand("SELECT * from IONS"); prversions.execute(); prversions.first(); %> -----Original Message----- From: Benoit Jodoin [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 10:11 AM To: [EMAIL PROTECTED] Subject: CachedRowSet Anyone here using a CachedRowSet? all examples i found looked like this : import sun.jdnc.rowset.*; sun.jdbc.rowset.CachedRowSet crs = new sun.jdbc.rowset.CachedRowSet(); this is the error message i get: class sun.jdbc.rowset.CachedRowSet is an abstract class. It can't be instantiated. CachedRowSet crs = new CachedRowSet(); http://www.javaworld.com/javaworld/jw-02-2001/jw-0202-cachedrow.html Well, i know you cant instanciate an abstract class. any ideas would be very helpful. thanks in advance Ben -- Benoit Jodoin <[EMAIL PROTECTED]> Vertical 7 ________________________________________________________________________ ___ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html