I recently took a quick look at doPSSelect and it appears to be missing quite a bit of needed code. It only accounts for dates and treats all other values as strings. Maybe this approach works in some drivers but not all? Maybe it works in all of them, but I would think there could be problems. Accounting for possibly null values is something else I found lacking, though I am not completely clear on how they are handled in PreparedStatements.
If you have column1 = ? in a prepared statement and you use ps.setNull(1, Types.SOMETYPE) is that expected to match all rows with null values for column1? I ask because in other sql you have to use the IS NULL special form. Anyway, null values will not be handled well using doPSSelect. john mcnally On Wed, 2002-06-05 at 12:38, Subhash wrote: > Are there any issues with prepared statments and the oracle driver?. > > I am doing a BasePeer.doPSSelect() and am getting an exception: > > I am running off of the HEAD version in CVS. > > and also I am passing the Connection to the PSSelect statement. > > Thanks in advance. -Subhash. > > java.sql.SQLException: ORA-00936: missing expression > at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) > at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) > at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) > at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) > at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643) > at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674) > at > oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870) > at > >oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363) > at > >oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314) > at org.apache.torque.util.BasePeer.doPSSelect(BasePeer.java:2180) > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
