Did you create the Statement object with the appropriate parameters?
Are you using Oracle's thin driver for the corresponding database server
version?
For example a scrollable updatable ResultSet:
Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rset = stmt.executeQuery("some select statement");
Dave D.
>Hi all,
>
>I'm having a problem calling ResultSet.absolute()
>
>The following code is in a servlet, and upon being run the request terminates
>giving a 500 error code, without throwing any exceptions
>
>the query itself is valid, and returns 15 records
>
>(running oracle8i database)
>
>Statement select = con.createStatement();
>ResultSet result = select.executeQuery(query);
>
>System.err.println("point 2a");
>
>System.err.println("query is " + query);
>
>System.err.println("pos is " + pos.toString());
>//result.absolute(pos.intValue());
>result.absolute(2);
>
>if anyone has an idea as to why this is happening, please let me know!!
>
>thanks
>Rob
>
>____________________________________________________________________
>Get free email and a permanent address at http://www.netaddress.com/?N=1
>
>___________________________________________________________________________
>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
