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

Reply via email to