hi,
i think ur using JDBC-ODBC bridge for connectivity.
sun has not implemented scrollable resultset feature in the current
release of JDBC-ODBC bridge.
they may do it in the next release.
plese check out with sun's online support for further confirmation.
good luck
zulfi
On Mon, 13 Dec 1999, Giri Lingamarla wrote:
> 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
>
___________________________________________________________________________
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
