CORRECTION
We use a JDBC 1.2 driver on our web server, not a JDBC 2.0 driver as I
thought. Oracle apparently has a JDBC 2.0 driver that could perform to the
specification.
I apologize for the bother and the considerably late response -- it was
accidentally sent in the first place (partly with a mail service change
here).
David Hildebrandt
-----Original Message-----
From: David Hildebrandt [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 20, 1999 8:10 AM
To: [EMAIL PROTECTED]
Subject: Re: JWS running servlets.
Hi:
For instance, many aspects of the JDBC spec are not supported by the Oracle
8i JDBC driver. The class, oracle.jdbc.driver.OracleResultSet
(javax\jdbc\oracle8\lib\classes111.zip) which implements the
java.sql.ResultSet interface, does so only partially. Many methods in
ResultSet are abstract in OracleResultSet, which makes texts like "JDBC API
Tutorial and Reference, Second Edition" something to be consulted with
caution since it focuses on the JDBC specification.
Does anyone know whether this is a function of whether the Oracle client is
treated as 'thin' when the connection is established?
For example:
String dBURL = "jdbc:oracle:thin:@sundown:1531:oradev";
String dBDriverName = "oracle.jdbc.driver.OracleDriver";
cATTDrugDB_ = new CATTDrugDB(dBURL, dBDriverName);
Regards,
David Hildebrandt
> -----Original Message-----
> From: Baglan Dosmagambetov [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, November 30, 1999 6:11 AM
> To: [EMAIL PROTECTED]
> Subject: Re: JWS running servlets.
>
> > java.lang.NoSuchMethodError: java.sql.ResultSet: method
> beforeFirst()V
> not found at tsa.agenda.agendaLe.doGet(Compiled
> Code)
>
> Looks more like and SQL error to me. Could be something with the JDBC
> driver. Which one do you use? Some drivers (majority that is) do not fully
> support JDBC spec.
>
> * Not sure if it could have an influence but SUN changed JDBC a bit (or so
> it is written in J2SE guide)
> -----------------------------------------------
> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com
>
> __________________________________________________________________________
> _
> 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
___________________________________________________________________________
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
