John,
You might want to make sure you are using the most recent JDBC drivers
available on Oracle's web site. We've been using JDBC to Oracle for a
couple of months and setString works just fine.
Regards,
Bib
------------------------------------------------------------------------
-------------------
Bob Withers Two things are infinite: the
universe and
[EMAIL PROTECTED] human stupidity, and I'm not sure
about
http://www.pobox.com/~bwit the universe. - Albert Einstein
------------------------------------------------------------------------
-------------------
----- BEGIN GEEK CODE BLOCK -----
Version 3.1 http://www.geekcode.com
GCS d- s: a+ C++ UO++ P L++ E--- W++ N++ o-- w++
O M V- PS PE Y+ PGP t+ 5 X++ r* tv+ b++ DI++ D--- G
e++ h--- r+++ y+++
----- END GEEK CODE BLOCK -----
On Wednesday, March 24, 1999 2:14 PM, John Larson
[SMTP:[EMAIL PROTECTED]] wrote:
> Good afternoon,
>
> I am having a problem with the setString not functioning correctly when
> connecting to an Oracle Database via JDBC. The following statents:
>
> selEmpQueryStmt.setString(1, frmEID);
> ResultSet rs = selEmpQueryStmt.executeQuery();
>
> returns the expected result when run against Access, (driver -
> Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
>
> With Oracle 8, the query returns an empty result set, which is
> incorrect. When the query is built with the value of frmEID inline
> instead using setString, the Oracle query returns the correct result
> set.
>
> The Oracle driver is:
> Class.forName ("oracle.jdbc.driver.OracleDriver");
> String url = "jdbc:oracle:thin:@proddb8";
>
> Why is this happening?
>
> The server is Netscape 3.5.1.
>
> Thanks,
> John
>
>
___________________________________________________________________________
> 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
