Thanks for your response,
I'm using the oracle thin client driver classes111.zip, which is the jdbc
driver designed for JRE 1.1.1 (for oracle 8i)
I'm using JRE1.3 - Was the absolute method implemented in the 1.1.1 JRE?
When I create the statement the way you mention, It returns error 500. Howcome
it does this rather than throw an exception??
thanks
Rob
David DeCruz <[EMAIL PROTECTED]> wrote:
> 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
____________________________________________________________________
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
