OC4J Bind Variables: Positional Notation
Date: Fri, 11 Jul 2008 11:47:36 +1000
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 220.127.116.11 has recently been upgraded. Since then queries have been failing as they are being submitted like this:
WHERE (col1 = ? and col2 = ?);
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.
RayReceived on Thu Jul 10 2008 - 20:47:36 CDT