BUG #1561: wrong detection of number of parameters in java.sql.PreparedStatement - Mailing list pgsql-bugs

From Ingolf Knopf
Subject BUG #1561: wrong detection of number of parameters in java.sql.PreparedStatement
Date
Msg-id 20050324153137.D8C1DF0F6F@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1561: wrong detection of number of parameters in  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1561
Logged by:          Ingolf Knopf
Email address:      iknopf@csc-dd.de
PostgreSQL version: 8.0.1
Operating system:   JDBC
Description:        wrong detection of number of parameters in
java.sql.PreparedStatement
Details:

"java.sql.PreparedStatement.executeUpdate()" throws "java.sql.SQLException",
if the prepared sql-string contains '?' within a C-like comment.

Example:
  select relname
  from pg_class
  where /*relowner = ? and*/
    relname = ?

In this case, the java.sql.PreparedStatement of PostgreSQL requires two
parameters, but I have only one.

pgsql-bugs by date:

Previous
From: "Olivier Thauvin"
Date:
Subject: BUG #1567: can't hide password with pg_autovacuum
Next
From: Ron Mayer
Date:
Subject: Re: BUG #1517: SQL interval syntax is accepted by the parser,