Hi,
good explanation in pages 589 of White's book "jdbc
api tutorial and reference, 2nd edition".
basically, you need to:
Connection con = Driver...
Statement stmt = con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
stmt.setFetchSize...
ResultSet rs = stmt.execute...
ron
--- "Kowaleski, Michael"
<[EMAIL PROTECTED]> wrote:
> i am trying to access the ResultSet first() method,
> using the default jdbc
> driver shipped with java 2 sdk v1.3 (JdbcOdbc.dll
> version 2.1) and the sun
> javaWebServer 2.0. i keep getting the following
> error:
>
> java.sql.SQLException: Result set type is
> TYPE_FORWARD_ONLY
>
> this is an example of what i need to accomplish:
>
> ResultSet xSet = y.executeQuery("");
> while (i) {
> ....
> if ( xSet.first( ) ) {
> do {
> if ( 0 == name.compareTo(
> xSet.getString( "name" ) )
> )
> color =
> xSet.getString( "color" );
> } while ( xSet.next( ) );
> }
> ....
> }
>
> can somebody provide me with an explaination of why
> this does not work?
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
__________________________________________________
Do You Yahoo!?
Send online invitations with Yahoo! Invites.
http://invites.yahoo.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
