Rob,
If you're using jdk/jre1.3 you must get the Oracle thin driver version
classes12.zip and nls_charset12.zip or higher from Oracle. The
classes111.zip file from Oracle will not support jdbc2.0 which provides
interfaces for scrollable result sets.
jdbc2.0 is bundled with jdk/jre1.3.
Hope this helps.
Dave D.
At 03:43 PM 11/3/2000 -0500, you wrote:
>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
