Hi,
Thanks alot for your help
It's most appreciated
regards
Rob
David DeCruz <[EMAIL PROTECTED]> wrote:
> 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
____________________________________________________________________
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
