add this code
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
driver should support jdbc2.0 .
jk
Neerav Aggarwal wrote:
> make sure that your JDBC driver is JDBC 2.0 compliant because first() and prev()
> methods are supported by the JDBC 2.0.
>
> ----- Original Message -----
> From: Santana, Jaime
> To: [EMAIL PROTECTED]
> Sent: Tuesday, December 14, 1999 12:19 AM
> Subject: How do I make a resultset scrollable ?
>
> Hi everybody !
>
> I my servlet I have a Query to a database which should retrieve serveral
> records, but when the query is executed the resultset pointer is in the last
> record so I tried to move to the first position, then I tried "rs.first();",
> and I get this error: java.lang.UnsopportedOperationException, I soppose it
> is because it�s not a scrollable resultset, so how do I make it scrollable ?
>
> Thanks in advance !
>
> �������������������������������������
> Jaime Santana Ruelas
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> ICQ: 19745928
> �������������������������������������
>
> > 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
>
> ___________________________________________________________________________
> 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
