The absolute method is implemented wth JDBC 2.0 api ie most probably
works with JRE 1.2 and higher,
Pls try usin the next method in a loop instead.
John
Rob Hazlewood <[EMAIL PROTECTED]>@java.sun.com> on 11/04/2000 02:13:55
AM
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: Re: [Re: ResultSet.absolute(int)]
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
___________________________________________________________________________
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
