parameter substitution problem in jdbc driver? (8.1)

From: Dave E Martin <postgresql-to(dot)dave(at)dave(dot)to>
To: pgsql-general(at)postgresql(dot)org
Subject: parameter substitution problem in jdbc driver? (8.1)
Date: 2006-01-27 21:13:00
Message-ID: 43DA8CDC.3080805@dave.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When a query of this form:

/* from xxx where yyy = ? */ select a,b,c,d from xxx where yyy = ?

is sent to the jdbc driver (as a prepared statement), it complains that
parameter 2 is not set. This is a query from hibernate3.1, with
hibernate's "generate comments in sql" option turned on.

I'm not really sure who is at fault here, or if this is one of those
unspecified things, but I would assume that parameter substitution
should not apply to comments?

Looking at the prepared statement in the debugger, it did indeed try to
do parameter substitution inside the comment.

Is the problem in the JDBC driver, in Hibernate, or in the JDBC spec?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2006-01-27 21:13:49 Re: parameter substitution problem in jdbc driver? (8.1)
Previous Message Doug McNaught 2006-01-27 21:01:25 Re: Are rules transaction safe?