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>

Hello All

Red Hat Linux 4.0
Oracle Database
Oracle Application Server

An OC4J application that had been running on Oracle Application Server has recently been upgraded. Since then queries have been failing as they are being submitted like this:

from table1
WHERE (col1 = ? and col2 = ?);

instead of

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.


Received on Thu Jul 10 2008 - 20:47:36 CDT

Original text of this message