OC4J Bind Variables: Positional Notation
From: Ray Feighery <rjfeighery_at_gmail.com>
Date: Fri, 11 Jul 2008 11:47:36 +1000
Message-ID: <8214a88a0807101847pf64cd16ve356ecdf465143ee@mail.gmail.com>
Date: Fri, 11 Jul 2008 11:47:36 +1000
Message-ID: <8214a88a0807101847pf64cd16ve356ecdf465143ee@mail.gmail.com>
Hello All
Red Hat Linux 4.0
Oracle Database 10.1.0.5
Oracle Application Server 10.1.2.0.2
An OC4J application that had been running on Oracle Application Server 9.0.4.3 has recently been upgraded. Since then queries have been failing as they are being submitted like this:
SELECT *
from table1
WHERE (col1 = ? and col2 = ?);
instead of
SELECT *
from table1
WHERE (col1 = :b1 and col2 = :b2);
This is more like an ODBC or Perl query using positional placeholders. I had thought that the jdbc driver handled this and converted the former to the latter.
Has anyone seen this before or know what setting controls this? Google and Metalink are not showing anything similar.
Ray
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 10 2008 - 20:47:36 CDT