Add two more arguments to the method create statement like:
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
The first argument must be one of these three constants:
TYPE_FORWARD_ONLY: nonscrollable result set(default)
TYPE_SCROLL_INSENSITIVE: Scrollable, does not reflect changes made
while it is still open
TYPE_SCROLL_SENSITIVE: Scrollable, reflects changes
The second argument must be one of the two:
CONCUR_READ_ONLY: read only(default)
CONCUR_UPDATABLE: updatable
Scrollable Result Set are supported in JDBC 2.0 and check your specific
driver documentation for more details.
Giri
"Santana, Jaime" <[EMAIL PROTECTED]>@JAVA.SUN.COM> on 12/13/99
01:49:57 PM
Please respond to "A mailing list for discussion about Sun Microsystem's
Java Servlet API Technology." <[EMAIL PROTECTED]>
Sent by: "A mailing list for discussion about Sun Microsystem's Java
Servlet API Technology." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
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
