Re: parameter substitution problem in jdbc driver? (8.1)

On Fri, 27 Jan 2006, Dave E Martin wrote:

> 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.
>
> Is the problem in the JDBC driver, in Hibernate, or in the JDBC spec?
>

This is the JDBC driver's fault.  There are a number of places it does not
correctly detect placeholders vs. comments/text, for example dollar
quoting is another one.

Kris Jurka