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
